cancel
Showing results for 
Search instead for 
Did you mean: 

CKF vs Formula

Former Member
0 Kudos

I am trying to understand the difference between a CKF and a Formula.

I know a Formula has all the math functions in the query designer (ex: all 5 of the percentage functions) where CKF only has the first 2 percentage functions.

CKF are reusable and Formulas are not.

But why the differences and when would you use one over the other?

Thanks, Keith Johnson

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Keith,

Formula is specific to the query.

CKF you can used across the queries.

Basically if your calculation is generic to all the queries and can be done with CKF ,we have to use CKF.

If the calculation is more complex and specific to the query we have to use Formula.

<i>Sudh</i>

Former Member
0 Kudos

I understand what you are saying, but don't understand why the functionality of the two are different. Why the restriction of not having all the percentage functions in a CKF like you do with a Formula.

In some cases, because of the limitation, you are forced to use a Formula if you want to use a percentage function, for the percentage of net sales to gross revenue, or something like that. Maybe this is the same across all queries, but you have to use a formula over and over again. Maybe not the best example, but just wondering why the difference in how the two work.

Thanks

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Keith,

It normally depends upon the requirement..

If you are going to use a certain Calculated Key figure across a lot of reports its wise to create a Calculated Key figure ..

On the other hand for requirements unique to a certain report I would prefer going for a formula in that particular report as I donot need it in other reports..

Formulae are more useful in cases where we need complex calculations which cannot be achieved by a simple Key figure..

Hope this helps

Ashish.