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