[NTG-context] max function in spreadsheettable

[juh+ntg-context--- via ntg-context <ntg-context@ntg.nl>]

Dear all,

I have a cell that calculates a value that may not be a negative value. 
If it is a negatiive value the cell should show zero.


\startcell[style=normal]
@ "0.2f EUR" $pauschale.eintag$ - ((D[row] * (0.2  * 
$pauschale.vororttag$)) + (E[row] * (0.4  * $pauschale.vororttag$)) + 
(F[row] * (0.4  * $pauschale.vororttag$)))
\stopcell

The $-variables will get resolved by Pandoc before ConTeXt comes into play.

As far as I understood the handdbook spreadsheets-mkiv.pdf it is 
possible to define lua functions inside a cell.

Who would you implement a max function that sets the value to 0 if it is 
negative?

TIA
juh

P.S. For German speakers: We try to implement a Reisekostenformular.
___________________________________________________________________________________
If your question is of interest to others as well, please add an entry to the Wiki!

maillist : ntg-context@ntg.nl / https://mailman.ntg.nl/mailman3/lists/ntg-context.ntg.nl
webpage  : https://www.pragma-ade.nl / https://context.aanhet.net (mirror)
archive  : https://github.com/contextgarden/context
wiki     : https://wiki.contextgarden.net
___________________________________________________________________________________