Hi Stephanie, I tried the DAYNAME("Candidate Creation Date"."Candidate Creation Date") in Recruiting, it is working as expected. It is returning the day name as 'Fri', Sun'. Thanks Nirmal

Hi, Add the below filter condition to your report, this will display only the most recent status records based on the submission identifier. MAX("Submission CSW Status - Historical"."Submission Historical Status Start Date" BY "Submission General Info"."Submission Identifier") ="Submission CSW Status -…

Hi, Try the below expression it will work, <?CURR_TOT_GAURENTEED_COMP DIV NEW_TOT_GAURENTEED_COMP?> Thanks Nirmal http://www.dataterrain.com

Hi Ruth, Your BIPublisher report is build using RTF or XPT layout? Thanks Nirmal

Hi Marco, you have to use char(10) not chr(10). Try the below formula this will work. replace(OTBI column, char(10), ' ') Thanks Nirmal http://www.dataterrain.com

Hi Karen, Try the below formula, it will give you the expected result. CASE WHEN "Worker"."Termination Date" BETWEEN timestampadd(SQL_TSI_DAY,(-6-(DAYOFWEEK(current_date))),CURRENT_DATE) AND timestampadd(SQL_TSI_DAY,-(DAYOFWEEK(current_date)),CURRENT_DATE) THEN 'Last Week' END Let us know if this resolves your issue.…

Hi Dario, We will following the below apparoach to select ALL values in the LOV. This will help you to handle the ALL paramerter values. Step 1: You have to modify the where clause in the dataset query as below, WHERE ( "Administration"."Employers"."Employer Name" IN (:EMP_NAME) OR 'ALL' IN (:EMP_NAME) ) :EMP_NAME is my…