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