YTD for the below expression..

[kavita25]

Hi,

Please help me with the logic for YTD..

My expression is :

sum(If(Val_Date >= Cal_MonthYear and Val_Date < AddMonths(Cal_MonthYear, 1), [Net Tractor Revenue (Domestic)]))

/

sum(If(Link_Date >= Cal_MonthYear and Link_Date < AddMonths(Cal_MonthYear, 1), [Net Tractor Revenue (Domestic)])))

I want to show YTD with the above expression..

For e.g If i select Sep Month then it should show from Apr to Sep..

stalwar1‌gwassenaar‌

Regards,

Kavita

[kavita25]

2nd sheet.

Please help me with this issue..

[kavita25]

stalwar1‌gwassenaar‌

Have u checked the app...

Please help me with this issue..

[kavita25]

gwassenaar‌

I have attached an app..Kinldy look into the app..

& Please help me to resolve it..

[Gysbert_Wassenaar]

Fix your data model first. The calendar is a data island and not linked with your other table. There are also only two Val_Date values in that table.

[kavita25]

Yess...There are only two date values coz its dummy data..

And my calendar is not linked with master calendar...

[kavita25]

stalwar1‌

I have attached the qvf..

Please look into this..