Comments
-
Thanks! I understand that what this did was identify the status of the invoices by due date and color accordingly. Works perfectly!
-
For Card #2, I changed the formula a little bit but wouldn't have found this without your help - thanks (CASE when CURRENT_DATE()>`DueDate` then CURRENT_DATE() else `DueDate` end)
-
horizontal bar graph. I would like to see the bar show current as green, 30 day as light green, 60 day yellow, 90+ as red.