Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
ryan2
Contributor
Contributor

Nested if statement with average formula

Please anyone can help me what is wrong wiht this statement?

 

if((Avg[F6 Ekran 6 (ar-arcelik_26011897).F6 Ekran 6 (ar-arcelik_26011897).Reel Çevrim])>(Avg([F6 Ekran 6 (ar-arcelik_26011897).F6 Ekran 6 (ar-arcelik_26011897).Hedef Çevrim (%85 OEE)])*1.2),rgb(200,51,51),
if((Avg[F6 Ekran 6 (ar-arcelik_26011897).F6 Ekran 6 (ar-arcelik_26011897).Reel Çevrim])>(Avg([F6 Ekran 6 (ar-arcelik_26011897).F6 Ekran 6 (ar-arcelik_26011897).Hedef Çevrim (%85 OEE)])*0.85),rgb(255,165,0),
if((Avg[F6 Ekran 6 (ar-arcelik_26011897).F6 Ekran 6 (ar-arcelik_26011897).Reel Çevrim])<(Avg([F6 Ekran 6 (ar-arcelik_26011897).F6 Ekran 6 (ar-arcelik_26011897).Hedef Çevrim (%85 OEE)])*0.85),rgb(0,255,0),


)))

Labels (1)
2 Replies
MayilVahanan

Hi @ryan2 

Try like below

if(Avg([F6 Ekran 6 (ar-arcelik_26011897).F6 Ekran 6 (ar-arcelik_26011897).Reel Çevrim])>
(Avg([F6 Ekran 6 (ar-arcelik_26011897).F6 Ekran 6 (ar-arcelik_26011897).Hedef Çevrim (%85 OEE)])*1.2),rgb(200,51,51),
if(Avg([F6 Ekran 6 (ar-arcelik_26011897).F6 Ekran 6 (ar-arcelik_26011897).Reel Çevrim])>
(Avg([F6 Ekran 6 (ar-arcelik_26011897).F6 Ekran 6 (ar-arcelik_26011897).Hedef Çevrim (%85 OEE)])*0.85),rgb(255,165,0),
if(Avg([F6 Ekran 6 (ar-arcelik_26011897).F6 Ekran 6 (ar-arcelik_26011897).Reel Çevrim])<
(Avg([F6 Ekran 6 (ar-arcelik_26011897).F6 Ekran 6 (ar-arcelik_26011897).Hedef Çevrim (%85 OEE)])*0.85),rgb(0,255,0)
)))

 

You've missed the ( for Avg() function as highlighted.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
ryan2
Contributor
Contributor
Author

thanks man.

you saved the day...