Condition with colour functions

trishita — Wed, 25 Nov 2020 16:16:04 GMT

I have two parameters and want to create an expression with condition cases and colour background on basis of it

It would be kind of nested IF loop:

if(field='Correction Done')

then

case 1:

(Deviation after sounding==Difference Vs Log Survey) then green()

case 2:

(Deviation after sounding - Difference Vs Log Survey ) !=0 then yellow()

else

red() //´(field='Correction Not Done')

I am not sure with the syntax.And where should I use to generate a graph with this function?

Re: Condition with colour functions

m_woolf — Fri, 18 May 2018 15:28:18 GMT

If I haven't misplaced a parenthesis, try:

if(field='Correction Done'),

if(Deviation after sounding=Difference Vs Log Survey,green(),

if(Deviation after sounding - Difference Vs Log Survey <>0,yellow())),

red())

You would put this in the Background color of the Chart Expression