When value is less than zero?
How do I set a calculation field so that when its value is less than zero the field is left blank?
Thanks in advance.
result = << your calc goes here >>
Case ( result ≥ 0 ; result )
Thanks. When I cut and paste:
result = << SARAH COMMISSION >>
into the formula field the following error message is displayed:
A number, text constant, field name or "(" is expected here.
Then, when I click OK it Then highlights the first > in your cOde.
If SARAH COMMISSION is the calculation name, it would be:
result = SARAH COMMISSION
It can be in the same field as the original calculation, for example instead of:
SomeField - 100
result = SomeField - 100
If you want to use another field, then it can be simply:
Case ( MyCalcField ≥ 0 ; MyCalcField )
Retrieving data ...