Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try this
Sum({$<LLR.PdCorrente-={'100'}, DtRef = {"=Day(DtRef) =1"}>} Saldo)
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)
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?
Try this
Sum({$<LLR.PdCorrente-={'100'}, DtRef = {"=Day(DtRef) =1"}>} Saldo)
Perfect, thank you!