7 Replies Latest reply on Sep 19, 2018 9:12 AM by Jim Dehner

    How to calculate WTD, MTD when we have  aggregate and Non- aggregate functions

    Suman Manu

      Hi ...

       

      I am trying to calculate WTD as below but it fails as "cannot mix aggregate and Non- aggregate comparison or results in 'if' expression"

       

      WTD: If DATEDIFF('week',[ Date1],TODAY())=0 and [Date1]<= TODAY() THEN [OTP] END

       

      Where as OTP is other calculated field

       

      Thanks in advance