I've been trying a few things out to change the color of a circle based on a number. My code doesnt work and looks like this:
If ( Omzet <= 3999, "#FF000", Omzet >= 4000, "#32CD32")
Omzet is the field with a number in it. Can anyone help?
Thanks for replying hpkeong,
I've tried this and I got this error:
I placed this code in the "Fill" option from the circle. Is this even possible to put code in there?
Thanks in advance,
I've got it to work right now, thanks alot for the help, it really helped. The final outcome:
If (ThisItem.Omzet <= 3999, Color.Red, Color.Green)
(**I didnt even call the "omzet" in the first code I posted here, because of the ThisItem I suppose**) Can u tell me if I'm right?
Read the announcement for more information!
Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.
Features releasing from October 2019 through March 2020
Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications