Question:
I have 10 CKFs in my query and I want to total them.
I tried using another CKF but it didn't work. It does work if I use a VKF. Are there any specific settings I need in the CKF that I don't know about?
The total CKF only ever holds the first of the totalled key figures. Is there any way to influence when the CKFs are calculated? For example, it may be that the total CKF is being calculated before my other CKF have been.
Answer:
it may be that the total CKF is being calculated before my other CKF have been.
not possible. Every CKF is broken down to it's basics, so no sequencing problem possible.
Look here for an example :
/forums/viewtopic.php?t=132872
For your problem : the first thing i would think of is the properties of the "sum-CKF" (like 'calculate result as'). Are you sure they are correct?
Answer:
The VKF works fine. The CKF does not.
I have tried it with the 'calculate result as' set to different settings but no luck so far. I'll keep trying and report back if anything works, or if nothing works.
Also...Can anybody tell me why, when I drag a calculated key figure from the left-hand side of the query designer to the columns, the properties are not taken with it?