Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm trying to total amounts for specific unit of measures using set analysis, but when I plug in my expression my numbers are too large.
For instance, if I narrow my selection to return 1 row and the VALUE is 100 for USD, my expression will return something completely wrong like 67432.
Here's my expression:
=num(sum({<UOM = {'USD'}>}VALUE))
Can anyone help me with this or point me in the right direction?
Hard to tell from the information you posted. Any chance that you upload a small sample QVW that demonstrates your issue?