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

    Set Analysis totalling specific

    David Capan


      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?