i have created a formulae as follow :
Formulae Q = (qty 1 ) x (qty 2 ) x (Weight 3 )/ 100
qty 1 = 21
qty 2 = 34
qty 3 = 42
Now if i use simple calculator then formulae q = 299.88
But in query execution, the output of Formulae Q = 296.99
I dont understand how this value got calculated by Query execution.
HOW TO SOLVE THIS ?
One thing i understood is that as i was multiplying Quantity and weight i used following defintion, so that units should not affect each other.......
Formulae Q = [nodim(qty 1 )] x [nodim(qty 2 )] x[nodim(weight 3 )] / 100
Still same issue:
Do i have to use the Aggregation Tab or Calculation tab in properties of formulae ?
the values are same if i click display data on infocube and is no different....