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