Skip to Content
0
Former Member
Dec 12, 2007 at 02:08 AM

Formulae definition --- erroneous output

29 Views

hi...

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:

Please advise

Do i have to use the Aggregation Tab or Calculation tab in properties of formulae ?

please advise..

the values are same if i click display data on infocube and is no different....