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

[former_member217770]

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

[Former Member · Accepted solution]

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 · Accepted solution]

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