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