Hi
I need to add a greater than symbol (>) as a prefix to any result of 14 for in-situ cbr. I have tried the following two expressions, neither of which are working.
if(count([InsituCBR.CBRValue])=14,'>14',")
'>' + if([In.SituCBR.CBRValue]=14,text(fixed([InSituCBR.CBRValue],1, false)))
Is anyone able to tell me where I am going wrong here?
Thanks
Hi Richard, I didn't test this, but looking quick, try something like this:
if([InsituCBR.CBRValue]>=14,'>14',fixed([InSituCBR.CBRValue],1, false))
If I don't have any typos, that should show the value if it is less than 14. If the value is 14 or greater, it will just print >14.
Answer Verified By: Richard Price