- SAP Community
- Products and Technology
- Technology
- Technology Q&A
- Calculate growth %

Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content

Calculate growth %

Former Member

- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content

on 04-06-2006 4:23 PM

59

Hello everybody,

I have a query where I have to calculate the growth between, let's say, 2006 training hours and 2005 training hours. If 2006 TH was 20 h., and 2005 TH was 11 h., growth would be 81,82%.

I can easily calculate that with two restricted key figures (one for each year) and using Percentage Variance in a formula (2005 % 2006). My problem is that I have to calculate the growth between many different KF's, so the final query looks like a mess to mantain (a total of 30+ restricted KF's and formulas), and is not as nice looking in excel as a regular query with its automatic totals.

Is there an easy way to do this? I have tried using the "Calculate result as variance" property, adding the year as a column and not restricting the ratios, but it doesn't seem to work (in this case result would be 40,5 which isn't the variance % between 2005 and 2006, or vice versa)

Thanks for any help,

-- Jose

- SAP Managed Tags:
- BW Business Explorer (SAP BEx)

Former Member

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content

04-06-2006
5:47 PM

Hi,

I dont think there is any other easy way to calculate variances between different columns

(Restricted key figures) other than by using the %.

"Calculate result as variance" wouldnt work as it is meant for different purpose.

Also even if you calculate using % or by any other means you will have your 30 + rest keyfigures and the % formulas .It will be the same number of columns finally

Usually we hide the some of restricted keyfigures which we dont like to display and look for few important variances which the end user is always interested.

Hope this Helps

-Doodle

Former Member

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content

04-07-2006
8:16 AM

Ask a Question

Related Content

- Using dynamic time calculations in Exception Aggregation is not supported. in Technology Q&A
- Partner-2-partner collaboration in Higher Education Sector in Technology Blogs by SAP
- Create a pareto chart on any model within the SAC in Technology Q&A
- Navigating Change with Business Process Management: A Strategic Imperative in Technology Blogs by SAP
- How do you fetch sales analysis data using the service layer? in Technology Q&A

Top Q&A Solution Author

User | Count |
---|---|

93 | |

7 | |

7 | |

6 | |

4 | |

4 | |

4 | |

4 | |

4 | |

4 |

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.