I am looking to get a month to month percentage need help

[Former Member]

OK so I know how I do this in Excel and I feel like translating it to Webi should be easy, but I am struggling.

I have some data that looks like this:

	01 - Jan	02 - Feb	03 - Mar	04 - Apr
Charges	112,265,746	125,734,751	145,922,192	115,661,872
Charges Month-to-Month	0	12%	16%	-21%
Excel Formula for Month - to - Month		=(C3-B3)/B3	=(D3-C3)/C3	=(E3-D3)/D3

Essentially the formula in Excel is taking the current month Charges and subtracting the previous month charges and dividing by the current month charges.

How should I go about creating this in Webi?

Any suggestions welcome.  Thanks!

[nscheaffer · Accepted solution]

Your Charges Month-to-Month formula should be...

(Charges-Previous(Charges))/Previous(Charges)

Something like this.

Does that work for you?

Noel

[Former Member · Accepted solution]

I think I need to figure our how to get the previous month's Charges. It is currently not a Measure in my query...

[nscheaffer · Accepted solution]

Do you have "Charges" as a measure? The "Previous" is a Web Intelligence function that will give you exactly what you seek.

Noel

[Former Member · Accepted solution]

WHAT?!?!  This is new to me. I am going to try it out now.  Thanks for the tip!

[nscheaffer · Accepted solution]

BTW, in my screenshot example above I formatted the "Month-to-Month" value as a percentage.

Noel

[Former Member · Accepted solution]

I did the same, that is how it will be presented. Thanks again for the help.