Additional math & logic in calculated columns

We use calculated columns in Brightgauge table gauges, but find we occasionally need more complex logic than is available in the calculated columns - for example,

• max, min
• coalesce
• conditional logic and comparisons like equal to, greater than, lesser than (for example, if A+B > X, then display X, otherwise display A + B)