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