Calculate current month YTD minus previous month YTD

[bhaveshp90]

Hello,

I have the table as shown below with YTD and MTD as expressions.

MTD = (Current month YTD) - (Previous month YTD).

My expression for MTD = YTD - Alt(Above(Total(YTD)), 0).

This expression is calculating correctly when selecting individual project number, but for all the project numbers selected It is calculating on per row basis which is completely wrong as shown in the below image;

Any idea on how to avoid it? (I want to calculate MTD as current month YTD - previous month YTD per Project_Number)

attached are files for your reference;

thanks

[sunny_talwar]

In your previous post I created a MonthYear field in the script, is there a reason you don't want to create MonthYear in the script and create it directly in the chart?

[bhaveshp90]

I have removed that tab which has the script. You can still use if needed;

Date(MonthStart(Snapshot_Date), 'MMMM-YYYY') as MonthYear,

[sunny_talwar]

I can add this, but the point is are you going to add this to your app? I mean is there a reason you don't want to have this in your app?

[sunny_talwar]

Check now....

[bhaveshp90]

It is not included in this test file. I will include this in my prod application, there is no reason not to include it.

[sunny_talwar]

Okay sounds good, I just wanted to know if there are concerns. But good to know that there aren't any.

[bhaveshp90]

stalwar1‌ the YTD and MTD are same when filtered by Date, look at this below;

But it is correct when selected individual project number;

[sunny_talwar]

Yes sir, because the project's are not repeating when you select a date

[bhaveshp90]

Okay, But the values are not correct when filtered by Date. Any idea on how to avoid it?

This is how the output should be when selected September month.