Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Last Receipted Cost

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
12 Replies
Not applicable
Author

Hi Jagan

It worked. On your formula you are just missing the single inverted commas. After the opening curly bracket and before the closing curly bracket.

Thanks again for your help.  Much apprecaited.

kind regards

Nayan

jagan
Luminary Alumni
Luminary Alumni

Hi,

No need of single inverted commas because it is a number.

Regards,

Jagan.

Not applicable
Author

Hi Jagan

Without the inverted commas, the formula looks like this

=

Max({<[Receipt Number]= {$(=Max([Receipt Number]))} >}

UNITCOST)

kind regards

Nayan