Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
OLSP
Contributor II
Contributor II

Firstsortedvalue greater than Zero

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

1 Solution

Accepted Solutions
Kushal_Chawda

@OLSP  may be below

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

View solution in original post

2 Replies
Kushal_Chawda

@OLSP  may be below

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

OLSP
Contributor II
Contributor II
Author

Thank you Kush, that was perfect help!

Also thank you for the very fast answer!

All the best for you, Oliver