Inspection Sheet Possibilities
- 15 days ago
Admittedly they don't make it easy.
try this
var text MyNumber = ToText([Measurement]);
var text NumberWithDecimalInTextFormat = $MyNumber
& If(not Contains($MyNumber,"."),"."); // deal with an exact integer measurement
var text IntegerPart = Left($NumberWithDecimalInTextFormat,".");
var text DecimalPart = PadRight(Right($NumberWithDecimalInTextFormat,"."),3,"0");
var text FinalResult = List(".", $IntegerPart, $DecimalPart);
If([Ø 0.328]<=0.333 and [Ø 0.328]>=0.323,"<span style='font-size: 15pt; text-align: left; color: green'>" & $FinalResult & "</span>",
[Ø 0.328]<0.323,"<span style='font-size: 15pt; text-align: left; color: red'>" & & $FinalResult & "</span>",
[Ø 0.328]>0.333,"<span style='font-size: 15pt; text-align: left; color: red'>" & & $FinalResult & "</span>")