4 Replies Latest reply: Aug 16, 2018 7:12 AM by Bala Bhaskar RSS

    If function on date - cash applied per team member today

    Ugur Arslan

      Dear all,

       

      I need to create an if function where I will be able to see the function of all cash applied per team member today.

       

      The expression is as following:

       

      Sum(if(

             [Cash App Type Code]='CASH'

      and [Cash App Count] = '1'

      and [Cash App GL Date] = '$(today())'

      ,[Cash App Count]))

       

      This if function doesn't give the results as per today due to this date filter: and [Cash App GL Date] = '$(today())'

       

      Can you please help me to define the right expression?

       

      Thanks

       

      Ugur