Skip to Content
0
Former Member
Jan 23, 2009 at 02:48 PM

CKF does not work if hierarchy is set to expand to level 1

18 Views

Hi,

I am doing an absence summary query and one of the requirements is to display long term absence and short term absence.

For this I have created to queries, each query with its own calculated KF thatu2019s shows short term absence result and long term absence result respectively.

As this is a summary the data should be at cost centre level, the calculated KF works if the hierarchy is expanded to maximum level, but unfortunately if the selected hierarchy is set to expand only to the 1st level the calculated KF does not work properly and returns the wrong results.

Does anyone have any suggestions on how to make the CKF work so it can produce the right results without all nodes of the hierarchy showing?

Thanks

Forhad