Allows you to add a formula in a field or a column of a table. The formula is calculated automatically
When filling a Plugnote
Example:
All the cells with a lock are formula's. Values cannot be modified when it's automatically calculated with a formula.
Setup
- The variable corresponding to field 1 is PN!A1
- The variable of a column of a table is F32!A1 for a formula in column 1 of a table
- The variable for the Total of column 8 of an F32 (or S32) in field 10 is PN!A10-8 for a formula in another field
Note: A series of functions that can be integrated into these formulas are available via the format setup or via the following link.
To Know
- The formula always starts with =
- To transform a text field into a number: TEXT(PN!A11)
- In a formula, the decimal separator is the POINT and not the comma
- Examples:
=SUM(PN!A2,PN!A1) sum of 2 fields
=TEXT(PN!A2-PN!A1, "H:MM") => 1:00 calculation of the difference between 2 fields using the HH:MM format
Limitations
- Not possible to test the validity of a formula without creating a plugnote
- Debugs are for the moment very difficult to find
--
Customer Success
If you have any questions, please contact our Customer Success Team