topic Re: How to subtract current month values with previous month values in straight table with dimension is year and columns as months in App Development

How to subtract current month values with previous month values in straight table with dimension is year and columns as months

Sravani5 — Tue, 04 Jul 2023 11:20:48 GMT

Hi,

Can someone help me to solve the below.

I have a straight table which has year as dimension and columns as months. I am trying to calculate variance (current month - previous month) but, facing issues when I am trying to subtract Jan month with dec month values.

Calculation has to be done at row level as per the screenshot and attachments below.

Thank you.

Re: How to subtract current month values with previous month values in straight table with dimension is year and columns as months

udit_k — Tue, 04 Jul 2023 12:53:13 GMT

Current month :-

sum({<Year={'$(=year(addyears(yearstart(max([Start Date])),0)))'},Month={'>=$(=month(yearstart(max([Start Date]))))<=$(=month(Max([Start Date])))'},Month=>}value)

Previous month:-

sum({<Year={'$(=year(addyears(yearstart(max([Start Date])),-1)))'},Month={'>=$(=month(yearstart(max([Start Date]))))<=$(=month(Max([Start Date])))'},Month=>}value)

Sub:-Column(1)-Column(2)

Re: How to subtract current month values with previous month values in straight table with dimension is year and columns as months

Sravani5 — Tue, 04 Jul 2023 13:17:04 GMT

Thanks for your reply..

My requirement has only month columns and we need to calculate only variance among them.