12 Replies Latest reply on Oct 26, 2013 3:41 AM by . Indumon

    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.