Skip to Content
avatar image
Former Member

Key fig with calculated totals in bex

Hello,

I have a req. where I have

Account --      Year                    Year

                       2013                    2014

Income          2000                     5000

   cash           100                       1000

   Others        1900                     4000 

Expenditure   1800                     3500

Surplus %      200                       1500

(Inc-Exp)

How can I calculate Surplus and show in Bex. I tried Calculated KF's but was not helpful.

Please help.

Regards,

Krishna

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Sep 09, 2014 at 05:07 PM

    Hi Krishna,

    if the income and expenditure are individual KFs,

    then you can jsut create a formula, to find these KFs difference. it will work.

    Regards,

    Sakthi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 09, 2014 at 05:55 PM

    Hi,

    Use Restricted key figure with restricting only Expenditure account and then multiply it with -1 in Formula key figure and use one more formula keyfigure to add all other keyfigure and check the total u will find surplus.

    Regards,

    Harish V.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Krishna with cell editor its very easy to format. But if you are not comfortable move to design studio its better to keep your calculations on Bex level though.