1 Reply Latest reply: Aug 14, 2013 11:33 AM by Stefan Wühl RSS

    Set Analysis totalling specific

    David Capan

      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?