Skip to Content
author's profile photo Former Member
Former Member

Summation Needed

Hi All,

I have a Calculated Key Figure(<b>say CKF1</b>) which has values like :-

-9

-8

100

20

9

8

---

120 == Result -


> when Summation is made in its Properties. <b>[a]</b>

90 == Result -


> when Nothing Defined is made in its Properties. <b> [c] </b>

Now, i have another formula which is getting calculated taking [c] as the value.

<b>But,</b> i want to calculate it as <i>taking [a].</i>

I have tried Formula Collision, Before/ After aggregation it didnt work.

Please suggest.

One lead which i have in mind it to make another key figure which somehow gets the <i>result of this CKF1.</i>

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 01, 2007 at 11:04 AM

    Hi Manu,

    You can create one Formula by taking result of that kf (SUMCT KF ->you can see this in Data functions of formula) and u can do the settings in the properties of that formula kf.

    Hope u understood........

    Pls assign points........

    Best Regards,

    SG

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 01, 2007 at 06:23 PM

    Hi Manu,

    In KF properties did you try

    Calculate result as summation

    Formula Collision : results from this formula

    and Calculate along columns

    Jaya

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Jaya,

      Thanks for your reply.

      I tried that also but it wont work.

      As it will bring the summation of the coloumn of my formula.

      I tried many permutations of properties and result row. Nothing worked till now.

      Gurus, Please help.

      Thanks,

      MG

  • author's profile photo Former Member
    Former Member
    Posted on Jul 03, 2008 at 12:43 PM

    This is not possible in 3.5 and in 7.0 i hear it can be done. not tried till now still closing the thred .. thanks for your replies.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.