Click on this link for the poll.
Possible to display results from two Case When statements in the same column in saved search?
I have created progress meters to display the % of total dollars logged and the % of billable dollars logged, which looks great! I was hoping to combine two of them in the same column using the usual formula, but can't figure it out. It looks something like this:
'% Total Complete: '||CASE WHEN ....... END ||'<br>'|| '% Billable Complete: '||CASE WHEN ....... END
I've tried wrapping the case statements in parenthesis and adding apostrophes in various combos, but the results always display "ERROR: Invalid Expression". I'm assuming I either have issues with my syntax (as I'm new to this) or it simply isn't possible. Can anyone help?