11 Replies Latest reply: Oct 31, 2016 11:41 PM by Shazad Nazir RSS

    While Multiplying Variables in Dimension & Measure

    Shazad Nazir

      Dear Experts,


      While multiplying variables in dimension i.e. $(vFGCompPrice) * $(vFGCompCurRate) * FGComponentQty it gives accurate result in Table chart.


      Whereas if I i want to use the same expressions in measure of the same Table chart or in KPI (we have to use measure so the result is not correct) i.e. Sum($(vFGCompPrice) * $(vFGCompCurRate) * FGComponentQty) the result is being multiplied by the factor of 9 or something.


      what could be the reason for this wrong result, I also tried to Aggr but could not get the desired results.


      Thanks & Regards