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

       

      Herbert