YTD

[stephenedberkg]

I attach the sample app

YTD value are not coming correct?

[PradeepReddy]

create a variable as vMaxMonth=Max(MonthID)

Use that variable in set analysis..

[stephenedberkg]

Dear pradeept

i tried this but its not working

[sunny_talwar]

What is the expected output you are hoping to see and in which object? Bar Chart or Text Box object?

[stephenedberkg]

if i select Feb i want to see both jan and feb values in bar chart

[sunny_talwar · Accepted solution]

Try this expression:

=Sum({<Year={$(=Max(Year))}, Months, Year, Month, MonthID = {"<=$(=Max(MonthID))"}>}

Aggr(If(Only({1}MonthIDS) = Max(TOTAL <ID> {<Month>} MonthID) + Only(TOTAL <ID> {<Month>} [lock period]),

Sum({<Year={$(=Max(Year))}, Months, Year, Month, MonthID = {"<=$(=Max(MonthID))"}>}sales)), ID, MonthIDS))

[stephenedberkg]

Dear Sunny,

thank you

this is working correct in sample app

but while i applied in my app its not working correctly

please find attachment

[sunny_talwar]

Did it work?

[stephenedberkg]

Dear sunindia

its working on that sample app only but its not working in my apps

i had post the app in previous command

[sunny_talwar]

Will be checking it.