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.

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

10|10000 characters needed characters exceeded

Related questions

• 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

10|10000 characters needed characters exceeded
• Former Member

Hi SG,

I am very sure that this doesnt works as i have tried it already.

Thanks,

Manu

• 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

10|10000 characters needed characters exceeded
• Former Member

Hi Jaya,

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.

Thanks,

MG

• 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.

10|10000 characters needed characters exceeded