Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
Regards,
Kavita
2nd sheet.
Please help me with this issue..
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.
Yess...There are only two date values coz its dummy data..
And my calendar is not linked with master calendar...