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