You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

icp sorting

in Reporting and Analytics for HCM 6 comments

Hi,

I am trying to sort the icp column so that the recurring records comes first and with in recurring records the latest records comes first and after recurring the non-recurring records should come. I am trying to do it in otbi. I have tried with custom sort column where I have used below logic -

CASE WHEN "Element"."Processing Type" like 'Recurring%' THEN 1 ELSE 2 END

Then sorting it with ascending order and add another descending sort on the effective start date column. But it is not working for me. Below is the screenshot -

Kindly, help.

Thanks

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!