12 Replies Latest reply: Mar 17, 2014 7:53 AM by Nayan Lalla RSS

    Last Receipted Cost

    Nayan Lalla

      Hi

       

      I have the follow table in my data base.  (see below)

       

      In a chart table, I want to create a formula to show the last unit cost receipted, which is R113.51.

       

      I've tried the following formulae , but does not work.

      • if(max(Receipt Number),Unit cost)
      • if(max(Receipt Date),Unit cost).

       

      Please can you help.

       

      kind regards

      Nayan

       

       

       

       

       

       

      Item CodeReceipt DateReceipt NumberQty ReceivedUnit Cost
      ABC12320131206RCP000000071017200113.51
      ABC12320131108RCP000000070385150117.27
      ABC12320131101RCP000000070239150117.27
      ABC12320131008RCP000000069536150117.27
      ABC12320130624RCP000000067101300117.27
      ABC12320130620RCP000000067050700113.04
      ABC12320130405RCP000000065550300113.04
      ABC12320130327RCP000000065354600113.04
      ABC12320130305RCP000000064910500113.04
      ABC12320121205RCP000000063375400107.11
      ABC12320121030RCP000000062405450107.11
      ABC12320121029RCP000000062365600107.11
      ABC12320121012RCP000000062013134107.11
      ABC12320120928RCP000000061779134107.11
      ABC12320120914RCP000000061503134107.11
      ABC12320120906RCP000000061279123107.11
      ABC12320120903RCP00000006120410107.11
      ABC12320120831RCP00000006118110107.11
      ABC12320120831RCP00000006118310107.11