QUANTITY CALCULATION

AppSheet AppSheet Q&A
,
1

I have 4 tables structured like this:

  1. PLANS_FERTILIZATION (parent)

  2. INTERVENTIONS (Child of PLANS_FERTILIZATION)

  3. FIELDS (parent)

  4. SECTORS_FIELDS (Child of FIELDS)

Each PLAN has many INTERVENTIONS, and both tables have a Ref column to the FIELDS tab ([FIELD_LINK]).

Each FIELD has many sectors.

I should get for each SECTOR a list of INTERVENTIONS. and this is easy with


SELECT(INT_RAD_SETTORI_VIEW[ID_INTERVENTO],
        AND([FIELD_LINK]=[_THISROW].[FIELD_LINK],
            [PIANO_LINK].[ATTIVO]=TRUE
           )
      )

my problem is to get in the inline view of the SECTOR’S INTERVENTIONS the “QUANTITY” field

it should be calculated with [SUP_SETTORE]x[QUANTITY_INTERVENTO].

Only I can’t create this formula in the INTERVENTIONS table because obviously each intervention is connected to many sectors of a FIELD.

Do you think it is possible to obtain data of this type? Or do I have to add a union table that for each intervention createss one row for each Sector?

2

If you could add some more details to the description with both Italian and English names for tables and columns, the community could help better. Also could you please mention in which table the [Quantity] column is. So screenshots of related columns in each table with description could help.