icon formula for currency

Question

i am trying to create an icon that will display when the [price] is equal to 0.

I tried an If statement and a Case statement and i am getting compatibility errors. What to i start the formula out with for currency type field? do i need to convert it to numeric first?

quickbasecoachd · Answer

There is a list of icons you can use here.

https://login.quickbase.com/db/9kaw8phg?a=ShowPage&pageid=160

You can make a formula Rich text field like this

IF([Price]=0, "<img src=https://images.quickbase.com/si/24/204-warning.png>")

quickbasecoachd · Answer

That got wrapped a bit.&nbsp; The beginning will look likeIF([Price]=0, "&lt;img src= ........

michellecoslet · Answer

How would i modify the formula to not show the symbol if the field is left blank? i only want the symbol when the user enters zero.

quickbasecoachd · Answer

Set the field properties on the Price field to not treat blank as zero.

Forum Discussion

icon formula for currency

Related Content

If currency(summary field) is blank formula help

Sample Data not reflecting Default Value (Field Properties, Numeric-Currency)

Formula Assistance

View icon missing from reports

Date Field Formula