Custom formula for Colored Measure Indicators
I am creating a P&L, and I am showing positive numbers for Revenue and Expenses so the Simple Mode for Indicators do not work to do comparisons. It works for Revenue green for an increase, red for decrease. But when it comes to Expenses it is showing green for a increase (which is bad and should be red) and red for decrease (which is good and should be green) . How can I code in the advanced section so that it works properly?