cancel
Showing results for 
Search instead for 
Did you mean: 

Please let me know how if there is any limitation to show overall result in bex query output

former_member217770
Participant
0 Kudos

Please let me know how  if there is any limitation to show overall result in bex query output

Scaling factor is working for some company codes. it is not working when query overall result is more.

It is giving * as value at end of the overall result

Regards,

Naiduz

View Entire Topic
Former Member
0 Kudos

Hi,


Scaling factor is working for some company codes. it is not working when query overall result is more.

 

It is giving * as value at end of the overall result

if you are running report of multiple company codes , then overall result would be * , because each company code has its own currency, and overall result doesn't support summation of multiple currencies.

you can use "nodim" to see sum-up value in overall result, also note, by using no dimension,  you wont see currencies(ex: SGD/EUR etc etc in report).

former_member217770
Participant
0 Kudos

i realized there are different currencies  for column with scaling factorw ith same company code. That is the reason  overall result showing *