Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Thanks, it didn't work either.
Is there a resource for this type of syntax?