Can anyone see an issue with this formula?

[samuel_brierley]

if([Average Speed (L1-L4)] < 30 , rgb(0,0,0),rgb(255,255,255))

[jerem1234]

Seems good to me, where are you using this formula? Could you post a little more about your issue?

[javier_florian]

Hi Samuel,

Try with-> if(num([Average Speed (L1-L4)]) < 30 , rgb(0,0,0),rgb(255,255,255))

what kind of data is your field?

[samuel_brierley]

The error was in the script, I Hadnt done the load correctly so there wasn't a link between the average speed and the table I was putting it in apologies guys but thanks