9 Replies Latest reply: Mar 20, 2014 9:11 AM by Nirmal Raj RSS

    1 Expression 2 Results

      Hi All,


      I have a bit of  strange one. Using the same expression, I am getting 2 different results when I change dimensions. When I use the most granular dimension,i.e. at customer level, I get the correct result, when I try a different dimension say at region level, I get a different result which is less. I am using the following expression:


      If((Sum([Bales Loaded])-Sum([Bales Delivered]))<=0,0,(Sum([Bales Loaded])-Sum([Bales Delivered])))


      Is it anything to do with the aggregate function?


      Any help appreciated