2 Replies Latest reply on Oct 3, 2018 4:38 AM by Imran Azam

    LOD with If conditon

    Imran Azam

      Hi guys

       

      i am trying to create a calculation field combing a fixed LOD with an if statement but i am struggling to create this, can this be done?

       

      below is what i have wrote bot it isnt working

       

      { FIXED [Account Name]: IF (max(0,[Daily revenue] * DATEDIFF('day',now(),[End Date])))>=1

      THEN true

      else false

      END)}

       

      thanks for any help