topic Error in expression in App Development

Error in expression

Chewitt — Sat, 16 Nov 2024 03:15:02 GMT

Hi,

Can anyone tell me what is wrong with this background colour expression:

if([Data Point 1] = "Variance",
if([Query Name] = "AA",
if(Value<-0.1,rgb(255,0,0),if(Value<-0.05,rgb(255,140,0),if(Value>0.1,rgb(0,255,0),if(Value>0.05,rgb(255,140,0),rgb(0,255,0))))),
if([Query Name] = "AB",
if(Value<-0.1,rgb(255,0,0),if(Value<-0.05,rgb(255,140,0),if(Value>0.1,rgb(255,0,0),if(Value>0.05,rgb(255,140,0),rgb(0,255,0))))),
if([Query Name] = "AC",
if(Value>0.1,rgb(255,0,0),if(Value>0,rgb(255,140,0),rgb(0,255,0))),
if([Query Name] = "AD",
if(Value>0.1,rgb(255,0,0),if(Value>0,rgb(255,140,0),rgb(0,255,0))),
if([Query Name] = "AE",
if(Value<-0.1,rgb(255,0,0),if(Value<-0.05,rgb(255,140,0),if(Value>0.1,rgb(255,0,0),if(Value>0.05,rgb(255,140,0),rgb(0,255,0))))),
if([Query Name] = "AF",
if(Value<-0.025,rgb(0,255,0),if(Value<=0,rgb(255,140,0),rgb(255,0,0))),
if([Query Name] = "AG",
if(Value>0.06,rgb(255,0,0),if(Value>0,rgb(255,140,0),rgb(0,155,0)))))))))))

Re: Error in expression

Kashyap_R — Mon, 17 Feb 2020 13:20:56 GMT

Try this

if([Data Point 1] = "Variance",
if([Query Name] = "AA",
if(Value<-0.1,rgb(255,0,0),if(Value<-0.05 and value>=-0.1,rgb(255,140,0),if(Value>0.1,rgb(0,255,0),if(Value>0.05 and value<=0.1,rgb(255,140,0),rgb(0,255,0))))),
if([Query Name] = "AB",
if(Value<-0.1,rgb(255,0,0),if(Value<-0.05 and value>=-0.1,rgb(255,140,0),if(Value>0.1,rgb(255,0,0),if(Value>0.05 and value<=0.1,rgb(255,140,0),rgb(0,255,0))))),
if([Query Name] = "AC",
if(Value>0.1,rgb(255,0,0),if(Value>0 and Value<=0.1,rgb(255,140,0),rgb(0,255,0))),
if([Query Name] = "AD",
if(Value>0.1,rgb(255,0,0),if(Value>0 and Value<=0.1,rgb(255,140,0),rgb(0,255,0))),
if([Query Name] = "AE",
if(Value<-0.1,rgb(255,0,0),if(Value<-0.05 and value>=-0.1,rgb(255,140,0),if(Value>0.1,rgb(255,0,0),if(Value>0.05 and value<=0.1,rgb(255,140,0),rgb(0,255,0))))),
if([Query Name] = "AF",
if(Value<-0.025,rgb(0,255,0),if(Value<=0 and Value>=-0.025,rgb(255,140,0),rgb(255,0,0))),
if([Query Name] = "AG",
if(Value>0.06,rgb(255,0,0),if(Value>0 Value<=0.06,rgb(255,140,0),rgb(0,155,0)))))))))))

Hope this helps

Thanks

Re: Error in expression

NitinK7 — Tue, 18 Feb 2020 13:13:50 GMT

Hi,

try this

= if([Data Point 1]='Variance',

if([Query Name]='AA',
if(Value<-0.1,rgb(255,0,0),
if(Value<-0.05,rgb(255,140,0),
if(Value>0.1,rgb(0,255,0),
if(Value>0.05,rgb(255,140,0),rgb(0,255,0)))))),

if([Query Name]='AB',
if(Value<-0.1,rgb(255,0,0),
if(Value<-0.05,rgb(255,140,0),
if(Value>0.1,rgb(255,0,0),
if(Value>0.05,rgb(255,140,0),rgb(0,255,0)))))),

if([Query Name]='AC',
if(Value>0.1,rgb(255,0,0),
if(Value>0,rgb(255,140,0),rgb(0,255,0)))),

if([Query Name]='AD',
if(Value>0.1,rgb(255,0,0),
if(Value>0,rgb(255,140,0),rgb(0,255,0)))),

if([Query Name]='AE',
if(Value<-0.1,rgb(255,0,0),
if(Value<-0.05,rgb(255,140,0),
if(Value>0.1,rgb(255,0,0),
if(Value>0.05,rgb(255,140,0),rgb(0,255,0)))))),

if([Query Name]='AF',
if(Value<-0.025,rgb(0,255,0),
if(Value<=0,rgb(255,140,0),rgb(255,0,0)))),

if([Query Name]='AG',
if(Value>0.06,rgb(0,255,0),
if(Value>0,rgb(255,140,0),rgb(255,0,0))))

)