cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dglawson Frequent Visitor
Frequent Visitor

How to use what if scenario in running total measure

Hi there,

 

I'm having some trouble getting this chart to work.

 

I have a bunch of dates (beginning of month)

 

 

2018-07-01

2018-08-01

2018-09-01

2018-10-01

2018-11-01

2018-12-01

 

I want to be able to make projects based on some numbers

 

a starting value (savings)

 

1st what if parameter (income)

 

2nd what if parameter (expenses)

 

Basically, I want to start with the starting value (savings).

 

And then for each month, add the income (what if parameter), and take away expenses (what if parameter)

 

For those that are more visual, ive included an example of what I'm trying to do below. 

 

Has anyone got any ideas on how to make this work?

 

problem

2 REPLIES 2
dglawson Frequent Visitor
Frequent Visitor

Re: How to use what if scenario in running total measure

I've tried using a running total quick measure, with the sum of the value being subtracted from the initial figure, though this does not pass through the dates.

Community Support Team
Community Support Team

Re: How to use what if scenario in running total measure

Hi dglawson,

 

"And then for each month, add the income (what if parameter), and take away expenses (what if parameter)"

 

<---- Could you clarify more details about your requirement and post measures you are using?

 

Regards,

Jimmy Tao