Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am writing some code at the moment to say that
When a value is higher than its target, the value turns green and when a value is less than its target, value turns red.
But what if there is no target, the values should stay default (black).
=if(
(if(Unit = '%', num(avg([Value]), '#,##0%'),
if(Unit = 'Days', num(avg([Value]), '#,##0'),
num(sum(Target), '#,##0'))))
>=
(if(Unit = '%', num(avg(Target), '#,##0%'),
if(Unit = 'Days', num(avg(Target), '#,##0'),
num(sum(Target), '#,##0')))),
vGreen, vRed)
Is there a way of adding if target is blank, the values stay black
Target | Value | Value |
---|---|---|
5 | 7 | 3 |
6 | 3 | 8 |
7 | 7 | |
something like this:
=If(IsNull(sum(Target), rgb(255,255,255),
if(
(if(Unit = '%', num(avg([Value]), '#,##0%'),
if(Unit = 'Days', num(avg([Value]), '#,##0'),
num(sum(Target), '#,##0'))))
>=
(if(Unit = '%', num(avg(Target), '#,##0%'),
if(Unit = 'Days', num(avg(Target), '#,##0'),
num(sum(Target), '#,##0')))),
vGreen, vRed)
)
Doesnt seem to like that.
just manage the first expression
If(IsNull(sum(Target),
why don't you use visual cues?