Hi All,
I am writing a report/search to display some information on a custom record, I need to highlight the working days between 2 date fields.
I can do this fine using the below formula as a formula (numeric) which works out the working days and this shows as working on the results of the search.
ROUND((TRUNC(({custrecord_dsa2_assessment_date}-{custrecord_dsa2_assessment_booking_date})/7)*5 MOD({custrecord_dsa2_assessment_date}-{custrecord_dsa2_assessment_booking_date},7) - CASE WHEN TO_NUMBER(TO_CHAR({custrecord_dsa2_assessment_date},'D')) < TO_NUMBER(TO_CHAR({custrecord_dsa2_assessment_booking_date},'D')) THEN 2 ELSE 0 END),0)I want to Highlight based on that search results, so I have used the same formula in the highlighting section as a formula(numeric) which highlights green if between 1-10, amber if between 11-15 and red if between 16-20 I then want to highlight if greater than 21 with a different colour and this is where the problem begins, the green. amber, red highlight work fine but when I add another highlight with the same formula and set to greater then 21 I get the following error when saving the search.Notice Your formula has an error in it. It could resolve to the wrong datatype, use an unknown function, or have a syntax error. Please go back, correct the formula, and re-submit. Search: DSA_V2 Search Formula: ROUND((TRUNC(({custrecord_dsa2_assessment_date}-{custrecord_dsa2_assessment_booking_date})/7)*5 MOD({custrecord_dsa2_assessment_date}-{custrecord_dsa2_assessment_booking_date},7) - CASE WHEN TO_NUMBER(TO_CHAR({custrecord_dsa2_assessment_date},'D')) < TO_NUMBER(TO_CHAR({custrecord_dsa2_assessment_booking_date},'D')) THEN 2 ELSE 0 END),0)I don't see why there would be an error in the syntax or formula as it works for the other values.Any ideas?