Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everybody,
I'm strugling with an expression that contains a nested if statement on the Text Color propertie.
If(([Colli/Ti/PO*Cse_Hgt] / [Reele_loc_Hgt])*100 >= 50.0,
If(([Colli/Ti/PO*Cse_Hgt] / [Reele_loc_Hgt])*100 >= 50.0 and [Reele_loc_Hgt] >= 185, green(),red()))
The above statement is working as it should but the first rule should contain one more logic comparison:
If(([Colli/Ti/PO*Cse_Hgt] / [Reele_loc_Hgt])*100 >= 50.0 and ([Colli/Ti/PO*Cse_Hgt] / [Reele_loc_Hgt])*100 <= 99.99,
When I implement this my rules are not applied.
I'll attach an example to see what I'm doing, I also use the visual cues.
Can anybody help me with this please ???
Kind regards,
Ambertje
Ok for that use the below.
If(([Colli/Ti/PO*Cse_Hgt] / [Reele_loc_Hgt])*100 >= 50.0 and ([Colli/Ti/PO*Cse_Hgt] / [Reele_loc_Hgt])*100<=99.9,green(),
If(([Colli/Ti/PO*Cse_Hgt] / [Reele_loc_Hgt])*100 >= 100.0 and [Reele_loc_Hgt] >= 185, green(),red()))
Hi,
Is this what you are looking for?
If(([Colli/Ti/PO*Cse_Hgt] / [Reele_loc_Hgt])*100 >= 50.0 and ([Colli/Ti/PO*Cse_Hgt] / [Reele_loc_Hgt])*100<=99.9,green(),
If(([Colli/Ti/PO*Cse_Hgt] / [Reele_loc_Hgt])*100 >=100.0 and [Reele_loc_Hgt] >= 185, red()))
Sorry Reddy but this is not correct,
Both If statements should result as green and all that doesn't match should be in red.
Ok for that use the below.
If(([Colli/Ti/PO*Cse_Hgt] / [Reele_loc_Hgt])*100 >= 50.0 and ([Colli/Ti/PO*Cse_Hgt] / [Reele_loc_Hgt])*100<=99.9,green(),
If(([Colli/Ti/PO*Cse_Hgt] / [Reele_loc_Hgt])*100 >= 100.0 and [Reele_loc_Hgt] >= 185, green(),red()))
Thank you so much, now I see how to build a nested If, totaly different then how I used nested If's in excel for example.
Kind regards,
Ambertje