Firstsortedvalue greater than Zero

[OLSP]

Hi there,

I have a lot of data containing this information:

- transaction ID

- partner

- date (ENDE)

- number of offers (ANGEBOTE)

I would like to have a table with the date of the last offer of a partner. Unfortunately it is possible, that a partner didn't make an offer, so there is a 0 in the data. 

My formula works fine, but doe not exclude all date with offer = 0.

dimension: partner

expressions: 

date(Max(ENDE))

FirstSortedValue(ANGEBOTE, -ENDE)

How is it possible to exclude all date with offer = 0 from the formula?

I know that I could exclude them in the LOAD, but then some other formulas in the app wouldn't work anymore.

Thank you in advance and best regards

Oliver

[Kushal_Chawda · Accepted solution]

@OLSP  may be below

FirstSortedValue({<ANGEBOTE={">0"}>}ANGEBOTE, - ENDE)

[OLSP]

Thank you Kush, that was perfect help!

Also thank you for the very fast answer!

All the best for you, Oliver