Hi, I've created the following table with a red traffic light if the profit is negative:
Traffic light gauge
Min = -7,000
red (since minimum is -7,000, which is negative)
As you can see, on the last row I have the minimum profit and a red traffic light gauge if at least one of the businesses have negative profit.
I cloned this table and I've been trying to create an indicator graphic (with a traffic light) that is red if minimum of those busenesses has negative profit (which means at least one business has a negative profit).
I can't use min(Profit) since profit isn't a dimension, but an expression that can only be calculated if the table has the dimension business.
Jonathan and Martin, thank you for your answers, but I'm affraid my Profit expression is a little complicated and doesn't work with your suggestions.
The expression is something like this:
=if(Credit_Limit>0 ,sum(Pendent)-sum(if((RegisteredYear='2012' and RegisteredMonth=$(Vmonth) ),Pendent,0))-sum(if((RegisteredYear='2012' and RegisteredMonth=$(Vmonth)-1 ),Pendent,0))-sum(if((RegisteredYear='2012' and RegisteredMonth=$(Vmonth)-2 ),Pendent,0))-Credit_Limit, 0)