Formula with SET expression

[Go-Anna]

Hi!

Do we have any detectives who can work out what is wrong with my formula?

=Sum({<ExEmployee={'YES'}, [DataType]={'Actual'}, YTDFlag={1} ,Period={">=Date(MakeDate(LEFT([Last day of Employment],4),MID([Last day of Employment],6,2)),'YYYYMM')"}>}[Price (SEK)])

I keep getting zero!

[Primrose]

Have you tried with YTDFlag={'1'}?

[tresesco]

@Go-Anna 

Try like:

=Sum({<ExEmployee={'YES'}, [DataType]={'Actual'}, YTDFlag={1} ,Period={">=$(=Date(MakeDate(LEFT([Last day of Employment],4),MID([Last day of Employment],6,2)),'YYYYMM'))"}>}[Price (SEK)])

[Go-Anna]

That really worked Tresesco! But........only when I have selected one (and only one) [Last Day of Employment] date. Is it possible to see the price without selecting a [Last Day of Employment]  date or if I select a number of dates??? Thanks.

[PrashantSangle]

use min() or max() or maxstring() or minstring() for that..

=Sum({<ExEmployee={'YES'}, [DataType]={'Actual'}, YTDFlag={1} ,Period={">=$(=Date(MakeDate(LEFT(minstring([Last day of Employment]),4),MID(maxstring([Last day of Employment]),6,2)),'YYYYMM'))"}>}[Price (SEK)])

[Go-Anna]

Thank you PrashantSangle I will work on it and see if I can get it to work 🙂