Date -1 on selected field

[sass]

Hello,

I am trying to get set analsyis to give me the day before selected day by user.

This set analysis is working : 

Sum({<[MasterCal.Day]={'$(=GetFieldSelections([MasterCal.Day]))'}>} sales)

Sum({<[MasterCal.Day]={'$(=max([MasterCal.Day]))'}>} sales)

But when I want to add -1, it doesn't work...

I tried this but it doesn't work...

Sum({<MasterCal.Day={"=$(=GetFieldSelections(MasterCal.Day))-1"}>} sales) or Sum({<[MasterCal.Day]={'$(=max([MasterCal.Day])-1)'}>} sales)

Can any one fix this please.

[sass]

I am trying to get set analsyis to give me the day before selected day by user.

This set analysis is working : 

Sum({<[MasterCal.Day]={'$(=GetFieldSelections([MasterCal.Day]))'}>} sales)

Sum({<[MasterCal.Day]={'$(=max([MasterCal.Day]))'}>} sales)

But when I want to add -1, it doesn't work...

I tried this but it doesn't work...

Sum({<MasterCal.Day={"=$(=GetFieldSelections(MasterCal.Day))-1"}>} sales) or Sum({<[MasterCal.Day]={'$(=max([MasterCal.Day])-1)'}>} sales)

Can any one fix this please.

[marcus_sommer · Accepted solution]

Try it with:

Sum({<[MasterCal.Day]={"$(=date(max([MasterCal.Day])-1), 'Format')"}>} sales)

Format must be the format from [MasterCal.Day].

- Marcus

[sass]

Thank you !!