Formulae definition --- erroneous output

[Former Member]

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....

[Former Member]

Are you only displaying 1 record on your query results? If you have other data, then the system will sum up the records and then do the calculation unless you have a global calculated key figure with the properties set to calculate individual values.

Could you be rounding up while the database has 20.79xxxx instead of 21? Just because the key figure shows 21, doesn't mean that the database value is 21 if your properties are set to 0 instead of 0.00.

[Former Member]

You can try to execute your query with the transaction RSRT. In the transaction you can explose your calcuted index so you can see exactly how it is calculated.

Mario

[Former Member]

Thanks Mario,

Please tell me in detail and steps by step procedure how to do that...

I know how to use RSRT transaction.

But then for query execution which options to use , because it has several options....

Tell me exactly step by step approach and exact options to chose before i run the execute and debug my query...

and in that execution how to explore the Calculated index.

How to debug and determine those calculated index...

how to understand what is going wron where ?????

[Former Member]

There is no need to chose any options when execute the query.

Put only your select options, when you have the result put the cursor on your index then push the buttom "Key figure definition" or buttom "Key Figure Display".

With the first you can see all component of you index with the value, the second rappresent a tree with the object that compose you index.

Mario