I want to compute the sum of amount of the previous month year from the max month year.
Can someone help please. Thank you.
Make sure that your field Monthyear has the proper data type required for the AddMonth function.
Or try below
Create this field in the script and use this in the expression.
Date(MakeDate(left(Monthyear,3), right(Monthyear,4), 1), 'MMM-YYYY') as Date
View solution in original post
Hi @abhijitnalekar ,
I'm able to resolve my issue based on your inputs. Thank you so much!
Great!!.. You are welcome