How to extract and show the last value per month.

[waszcma1]

Hi,

Could you please help me to solve this small problem?

How to create monthly aggregation and take the "Ballance ammount" for the last day of the month.

Please be aware that there are more than one transaction on the last day so then the load order should be consider.

My guessing is that I have to run this at the script load phase, and use previous function when date will change to the next then I can call the last value... but still not sure how it make happen or is it the right way to do it.

My idea: if(month(Previous(Date))>month(Date),Ballance,0) as monthly_result

Example: