Skip to Content
0
Former Member
Nov 21, 2008 at 06:47 AM

Need Calculation Script or Formula for Dimenion

12 Views

Dear All,

I have Account and Category dimensions. I am trying to prepeare Budget Report.

Below is a sample: I am getting report sa blow:

BudgetItems| Yr-2008 | Yr-2009 |

_____________________________

IT Dept | 200 | 220 |

HR Dept | 300 | 330 |

But i want to something as below inculding "Change" and "%Change"

BudgetItems| Yr-2008 | Yr-2009 | Change | %Change |

_______________________________________________

IT Dept | 200 | 220 | 20 | 10% |

HR Dept | 300 | 330 | 30 | 10% |

Can any body help by guiding me how write Formula or Script.

Please do needful.

My Gmail ID: satish.mba.sap

Thanks a lot in Advance.

Regards,

Satish.