Vizlib Home Try Vizlib

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?

  • Hi Chris,
    Can you elaborate a little bit more about your use case?
    Which Vizlib Chart do you use for it (Finance Report, Pivot Table, Table)?
    Do you have both expenses and revenue in the same measure? or they are separate measures?

    Please note your unique ticket reference (#29623) and URL

Login to post a comment