GST Billing Software

header image

Formulas

Erachana Line

Formula Syntax Description

Formulas start with a "=" or a formula prefix (any letter and number followed by a colon; the prefix is not interpreted yet, but is used later to separate different formula-namespaces. Therefore, the following formulas are equivalent:

report:1

References to external data-fields are expressed using square brackets.

=[yourfield]

If a field's name contains special characters, first surround it with double quotes:

=["[Reseller].[Reseller.Reseller].[All Resellers].[Azabujuban]"]

Possible operators are:

• Basic computation: +, -, *, /

• Percentage: %

  • Power: ^

• String-concatenation: &

• Comparisons: =, <>, <, <=, >, >=

• Formulas can have braces.