6 Replies Latest reply on Dec 7, 2017 7:13 PM by arvindgarg

    How to handle if condition Error.

    rakesh jadhav

      Hi team,

      Please find the attachment  of twbx and word file .i do have if condition with [system type],

      but when i put  SUM([Paid Amount])/SUM([Fx Rate]) it gives error ,

       

      but if i put   [Paid Amount]/[Fx Rate] its run well.

       

      but i need sum of all  paid amount  / sum of all fx rate in Quarter wise.

       

      I need to resolve it didn't putting  [system type] in filter.

      I am looking for same as  If_cal output which is there in visualization  but i need that using following condition :

       

      if Condition with

      [System Type]='Partially Released' or [System Type]='Released'

      or [System Type]='Settled'

       

      THEN

      SUM([Paid Amount])/SUM([Fx Rate])

      END

       

      Please help how to handle that error.

      Advanced in Advanced

       

      Rakesh Jadhav