4 Replies Latest reply on Oct 25, 2013 12:30 PM by Matt Lutton

    Calculated Field without showing related dimension

    Abdullah Alahdal

      First of all, please excuse my bad English. I will try my best.

       

      I am trying to make a calculated using IF function based on the return of one dimension 'in my example called uom'. The calculated field works very fine when I show the related field 'uom' in the view; however, when I remove 'uom' it total number of QTY is not correct.

       

      Please check attached picture which are self-explanatory.

       

      For Example: the total QTY of the 1st SKU should be 537.08 not 25,910

       

      I have attached the Workbook package for easy reference. Please help.