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?
----
The image below is to provide a visual reference:
- Stacked results from custom fields, with bold labels. (Essentially, what I want the progress bars to do)
- The text formula column.
- Progress meter case when statement 1
- Progress meter case when statement 2