Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
@OLSP may be below
FirstSortedValue({<ANGEBOTE={">0"}>}ANGEBOTE, - ENDE)
@OLSP may be below
FirstSortedValue({<ANGEBOTE={">0"}>}ANGEBOTE, - ENDE)
Thank you Kush, that was perfect help!
Also thank you for the very fast answer!
All the best for you, Oliver