FirstSortedValue

[agni_gold]

Hi ,

I am using below expression for calculating sale in maximum date.

=FirstSortedValue({<[ERP Amount USD] -= {0}>} [ERP Amount USD],-[Invoice Date])

But it is returning null values for some rows.

Regards,

Agnivesh

@Sunny T

gwassenaar‌

[sunny_talwar]

May be with distinct:

=FirstSortedValue(DISTINCT {<[ERP Amount USD] -= {0}>} [ERP Amount USD],-[Invoice Date])

[Chanty4u]

AGGR( nodistinct     MAX(           AGGR( nodistinct           <formula>

                    ,[ERP Amount USD], [Invoice Date])

     )

, [ERP Amount USD])

[Chanty4u]

you can try with these two ways:

FIRSTSORTEDVALUE (OrderDate, – aggr(sum(Sale)) )

or

=Max ( aggr ( sum ( Sale ),OrderDate ) )

• Re: Calculate the maximum value

[agni_gold]

Not working

[Kushal_Chawda]

try

=FirstSortedValue(distinct {<[ERP Amount USD] -= {0}>} [ERP Amount USD],-[Invoice Date])

or

Sum({<[Invoice Date]={"$(=max([Invoice Date]))"}>} if([ERP Amount USD]>0,[ERP Amount USD]))

[agni_gold]

when i am using DISTINCT , it is giving syntax error,

but on every max date lot of transactions happen , so i need sum (ERP Amount USD) for that date.

[Clever_Anjos]

If you have more than one [Invoice Date] which value you want to show?

[agni_gold]

max(invoice_date)    , and sum(erp amount usd).

[agni_gold]

max(invoice_date)    , and sum(erp amount usd) on max(invoice_date)