Need Help??

[Nagaraju_KCS]

Hi Community,

How to calculate YTD in fiscal year ...

i am using this expression, but it's not working..

sum({<[Date] = {">=$(=YearStart(max([Date]))) <=$(=max([Date]))"},Year =, Month = >} Amount)

please anyone can help me out..

[PrashantSangle]

Hi,

Try this,

sum({<[Date] = {">=$(=Date(YearStart(max([Date])))) <=$(=Date(max([Date])))"},Year =, Month = >} Amount)

Regards

[senpradip007]

Try like:

sum({<[Date] = {">=$(=YearStart(max([Date]),0,4)) <=$(=max([Date]))"},Year =, Month = >} Amount)

[PrashantSangle]

Hi,

Considering your Fiscal Year started from April

then use AddMonths() in your expression like,

sum({<[Date] = {">=$(=Date(AddMonths(YearStart(max([Date])),4))) <=$(=Date(max([Date])))"},Year =, Month = >} Amount)

Regards

[#5]

Expression seems to be correct. you can share your qvw to have a check.