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



      thanks for any help