Summation Needed

[Former Member]

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>

[Former Member]

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.

[jaya_mogali]

Hi Manu,

In KF properties did you try

Calculate result as summation

Formula Collision : results from this formula

and Calculate along columns

Jaya

[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

[Former Member]

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

[Former Member]

Hi SG,

Thanks for the reply.

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

PLease suggest something different.

Thanks,

Manu

[Former Member]

Hi SG,

Thanks for the reply.

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

PLease suggest something different.

Thanks,

Manu