APPENDIX Formula Language Reference

negative, or zero. SIGN returns a numeric value of –1 for negative numbers, +1 for positive numbers, and 0 for zero. SIGN(number) CASE SIGN([Profit]) WHEN 1 THEN "Profit" WHEN -1 THEN "Loss" ELSE "At Cost" END returns the string value “Profit” if the Profit database field is greater than zero, “Loss” if the ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download