6 Replies Latest reply: Jan 26, 2015 4:42 AM by Ján Turoň RSS

    NumSum and If statement in Expression

    Ján Turoň

      Hello,

      can you help me with this problem?

      I have this definition in expression:

       

      =NumSum((100-(Sum(U504)/Sum(U604))*100)/100)

       

      and a I need to combine it with if statement like this:

       

      =Sum( if( OBDOBIE >= $(vStartDateCompare) AND OBDOBIE <= $(vEndDateCompare), NumSum((100-(Sum(U504)/Sum(U604))*100)/100)) )

       

      but it doesnt work.

       

      thx.