Hey guys. I finished building my tables, however, my calculated column is not doing the calculations.
My tables look like this:
1. Customer (table) - With the column:
Name
And a relationship with the Order table
2. Plants (table) - With the columns:
species name
Unitary value
Stock
And relationship with Order table
3. Order (table) - With the columns:
Customer Name - searchable type where I reference the Customer table (to pull the Customer name)
Plant Name - searchable type where I reference the Plant table (to pull the Plant name)
Quantity - where the order quantity is informed
Order Amount - where I made a calculated field, like this: the Quantity column * the Value column (from the Plant table)
I attached the image of the field
However, when I make a record, the "Order Amount" column is blank.
How do I proceed? Thanks!
