Re: how to avoid 0.0 in an org-table

2021-07-07 Thread Uwe Brauer
>>> "GM" == Greg Minshall writes: Hi Greg > Uwe, > your mileage may vary, but try > : #+TBLFM: $5=vsum($1..$4);f1::$6=min(10,$4)*0.1;%0.1g > (=man 3 printf= sort of implies that behavior might work for =%g=.) Oops, thanks a lot I just did not realized the %g option (and I have used printf in

Re: how to avoid 0.0 in an org-table

2021-07-07 Thread Greg Minshall
Uwe, your mileage may vary, but try : #+TBLFM: $5=vsum($1..$4);f1::$6=min(10,$4)*0.1;%0.1g (=man 3 printf= sort of implies that behavior might work for =%g=.) cheers, Greg

Re: how to avoid 0.0 in an org-table

2021-07-06 Thread Uwe Brauer
>>> "RM" == Roger Mason writes: > Hello Uwe, > Uwe Brauer writes: >> I obtain 0.0 in the last column, this looks bad, any idea how to avoid >> it? > I think you can use a printf format specification in the formula. Thanks I tried #+begin_src elisp | || | | Res | Min | |-+

Re: how to avoid 0.0 in an org-table

2021-07-06 Thread Roger Mason
Hello Uwe, Uwe Brauer writes: > I obtain 0.0 in the last column, this looks bad, any idea how to avoid > it? I think you can use a printf format specification in the formula. Cheers, Roger