Last month period date

[mario-sarkis]

‌hey all,

if i need to calculate the sum of amount of the maximum periode on last month how can i write it in the set analysis?

hope you can help

thanks

[sunny_talwar]

May be this:

{<Date = {"$(=Date(Floor(MonthEnd(Today(), -1)), 'YourDateFieldFormat'))"}>}

[mario-sarkis]

‌my format field is num should i use the same expression ?

[sunny_talwar]

Something along these lines:

{<Date = {"$(=Floor(MonthEnd(Today(), -1)))"}>}

[mario-sarkis]

‌sorry sunny to disturb u but the pervious month sometimes doesnt have all days i just need The maximum period date in last month and my field is number type

[sunny_talwar]

Do you have a sample you can share?

[mario-sarkis]

‌unfortuantly i cant share my data online but as an example

lets say we are in march i need to calculate the sum of a balance in feb of list of ids but this balance is a snap shut balance. in my database i don't have all days cause the balance is saved one per week.

my request is the calculate this balance in the maximum periodedate in feb (it could be any day in feb)

hope this explanation can help