Dear Gurus,
In BEx, we have option to calculate result as nothing defined or summation.
In our case, result from nothing defined is different from summation and this is a common.
so, we have set to always have calculate result as summation.
for example:
1. sales quantity have result 100 (calculate result as nothing defined)
2. sales quantity have result 200 (calculate result as summation)
=> we refer to 200 as this is the correct one.
the problem comes when another column is using that column in the calculation.
for example: sales value = sales quantity * price.
the result row of sales value is using 100, not 200.
although as i mentioned, we have set summation as the calculation in query.
also, whatever the calculation we set in sales quantity.
the result row of sales value always refer to nothing-defined-value which is 100.
so, is it possible to calculate using this summation-value in Bex query?
or if not, can we just use modify-table-class / java script?
we are looking for workaround solutions.
please help to give input ðŸ˜Š
thanks
Hi,
I understand that property is only for display purpose so in case you need to use that value further in calculations of other columns then it doesn't work.
So at bex level to achieve the same----Make anew formula and put your sales quantity in it---Hit the aggregation tab---Exception aggregation as Total--Reference characteristic----choose the most granular char on which you are getting new combination of row.
Refer the below docs on further assistance on the same.
Hope this helps.
Regards,
AL
Add a comment