Hi All, Is there an expression to show an upward directed arrow or a downward directed arrow next to a numerical value, if that numerical value exceeds or is less than a certain number? For example, I have a table consisting of columns, each for a blood investigation (eg: Haemoglobin, White cell count, platelets etc.) If the user enters a value in to the numerical text field of Haemoglobin, if it is less than 12, I’m trying to get a “downward directed” arrow shown immediately next to the haemoglobin value, and if the user enters a value over 17, an “upward directed” arrow next to the haemoglobin value. I wrote the following expression to the AppFormula of Haemoglobin (decimal type column), but it didn’t work. =IFS([Haemoglobin]>17,CONCATENATE([Haemoglobin]," ↥"),[Haemoglobin]<12,CONCATENATE([Haemoglobin]," ↧"))
Can someone help me? Thanks!