How to Create a Custom Math Formula

When you add Magic Text, the last option in the menu is "New Formula...". When you select this option, a chip called "Custom Formula" is added to your text box. To enter the formula:

  • Click on the Custom Formula chip to open the formula editor

  • Here you can type any number, as well as the following operators

    • + (for addition)

    • - (for subtraction)

    • / (for division)

    • * or x (for multiplication)

  • You can also insert a Magic Number by clicking the Magic Number icon

    • Magic Numbers use Number properties from your database

    • You can also filter Magic Numbers that are Counts, Sums, Averages etc of related collections

Let's take a look at an example. If we have the total cost for a trip and the number of people who can go on that trip, but want to see the trip cost per person, we can use a custom math formula.

  1. Insert a text box

  2. Select the red accented letter to insert Magic Text

  3. Select New Formula from the popup list

  4. Click on the pencil icon to open the formula editor

  5. Click on the Magic Number icon to select Trip Cost

  6. Enter "/"

  7. Click on the Magic Number icon to select Group Size

  8. As with any numbers, you can edit the prefixes/suffixes and format custom formulas as well