Filtering a certain Day number in Set analysis

[william_fu]

Any ideas why the following expression doesn't work?

Sum({$<LLR.PdCorrente-={'100'}, Day(DtRef)={1}>} Saldo)

I want the measure to only sum the values for the first day of each month.

[sunny_talwar]

Create a new field in the script and use the field name in set analysis

Day(DtRef) as DayRef

and then this

Sum({$<LLR.PdCorrente-={'100'}, DayRef={1}>} Saldo)

[william_fu]

Thanks for the quick response.

Anyway to achieve this without messing with the script?

I'm currently working with just the auto-generated script, and I'm not quite comfortable to press the "Unlock" button yet.

Also, why doesn't the auto calendar create a day field?

[sunny_talwar · Accepted solution]

Try this

Sum({$<LLR.PdCorrente-={'100'}, DtRef = {"=Day(DtRef) =1"}>} Saldo)

[william_fu]

Perfect, thank you!