Max value help

[amit_saini]

Hi Folks,

Based on max KPI value need to have corresponding value in UKURS . See below

Requirements : Total Cost:  Sum(Sales) * UKURS value corresponding to max KPI field.

Based on selections below , I'm having 4.0394 as value corresponding to Max KPI value . so this value I need multiply in Total cost cal.

Thanks,
AS

[sunny_talwar]

Not sure if I understand completely, but may be this:

=Sum(Sales) * Only({<KPI = {"$(=Max(99999999 - GDATU))"}>}UKURS)

[jagan · Accepted solution]

Hi,

Try like this

=Sum(Sales) * Only({<KPI={$(=Max(KPI))}>} UKURS)

Hope this helps you.

Regards,

Jagan.