Set Analysis totalling specific

[Anonymous]

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?

[swuehl]

Hard to tell from the information you posted. Any chance that you upload a small sample QVW that demonstrates your issue?