Oh, no
you see the initial requirement was to have two decimals always.
LSWipo used the rounding
fixnum(round(Q1,2))
And I proposed the solution
{if(strpos(fixnum(round(Q1,
2)),'.')==0,join(fixnum(round(Q1,
2)),'.00'),if(strpos(fixnum(round(Q1,
2)),'.')==strlen(fixnum(round(Q1,
2)))-2,join(fixnum(round(Q1,
2)),'0'),fixnum(round(Q1,
2))))}
Now there was the next requirement
that there is only one true decimal, and the second decimal is zero
This is covered by doing the rounding to only one decimal. The displayed number of decimals is done by the string manipulation.
{if(strpos(fixnum(round(Q1,
1)),'.')==0,join(fixnum(round(Q1,
1)),'.00'),if(strpos(fixnum(round(Q1,
1)),'.')==strlen(fixnum(round(Q1,
1)))-2,join(fixnum(round(Q1,
1)),'0'),fixnum(round(Q1,
1))))}
But now I see that my screenshots were missing.
Joffm