Skip to Content
Jun 17, 2016 at 03:20 AM

Hierarchy with CEIL function in BEx


Hi Experts,

I facing problem while using CEIL function with hierarchies in BEx query.

Example records

org unit employee no.of.hours(calculated kf with ceil function)

org1 emp1 2.3

org1 emp2 2.4

Here org unit is hierarchy characteristic and it is hierarchy enabled in query.

when we expand the hierarchy in output of the report it showing total value as 6 (ceil(2.3) + ceil(2.3) = 3 + 3 = 6)

But we I collapse the hierarchy it showing output as 5 ( ceil(2.3 + 2.3) = ceil(4.6) = 5).

It is giving problem for users with high count of hours mismatching under some org units.

can you please provide me the solution which give 6 as output in both expand and collapse actions.

Please provide solution at BEx level(requirement need to be implement in BEx query only).

Thanks in advance