Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
i have two arrow red and green i want to show green arrow when my target is less than actual and red when target is greater than green arrow..
how i can set condition?
if(sum(target) > sum(actual),'path for green arrow','path for red arrow')
Not Working, its simply giving me the path whenever any condition fulfilled..
Alternatively you can also achieve this using unicode character instead of using image files by using expression like:
if([Actual]>[Target],'▲','▼')
AND in the expression text colour option type:
if([Actual]>[Target],rgb(121,170,85),rgb(186,75,69))
Change the representation to Image