How to get Sum of multiple dates in addmonth or Add year function

[Anonymous]

Hi Team,

i use below expression for get sum of sales at select date vs same day as last year

=num(sum({1<U_SalesDate = {"$(=date(Addmonths(U_SalesDate,-12,0),'DD/MM/YYYY h:mm:ss TT'))"}>}

U_Value),'##0.00')

but its work only single day its not working with multiple date selection in calendar input field.

Kindly solve this

Regards

SASIKUMAR

[Anonymous]

i attached sample file u r ref.

u select any one date on using  calendar date filed & after select any two date.

and give the solution where i have to stuck

[Anonymous]

i attached sample file u r ref.

u select any one date on using  calendar date filed & after select any two date.

and give the solution where i have to stuck

[Kushal_Chawda · Accepted solution]

Please check the variables , I have created on front end.

[Anonymous]

Thanks kush141087

its Working

‌

[Kushal_Chawda]

Awesome