0 Replies Latest reply: Sep 26, 2018 6:32 PM by Ali Ahmad RSS

    Count dates where expression is below an input variable.

    Ali Ahmad

      Hi,

       

      So I have a app where I am trying to have a % calculation that I compare to a % set by a range slider. If it is below the slider I want to show it, or else I don't want to show it. I have that so far:

       

      Capture.PNG

       

      Now what I want is I want to count how many days there are that are below the InputVariable from the slider:

       

      Here is a very simple version of the calculation:

       

      IF

      (

           Sum(Amount) / 7,5 <= $(vInputVariable),

                1,

                Null()

      )


      So now I want to count how many dates this is happening for also.


      I've tried with:


      Sum(Aggr(IF(Sum(Amount) / 7,5 <= $(vInputVariable),1,Null()),Name,Date)) but that won't let me remove the 0 values.


      Any suggestions?


      Best,


      Ali A