Expression to multiply the variable of a column of a table A with a column of a table B.

[anonymous]

Hi everyone,

I have a table A called Rate 2022.
This table gives the price/hour of the services.

I have my table B with the details of the offers.
I would like to be able to calculate directly in my total column the number of people with the number of days with the hourly rate.

Probably there must be an easier way.

Thanks in advance.

Here is the idea of what I am trying to do:

(([Nombre de jour monteur][Nombre monteur]) Tarif 2022[Tarif monteur]) = Total

[Marc_Dillon]

@Mickael_Guillor

Here is the idea of what I am trying to do:

(([Nombre de jour monteur][Nombre monteur]) Tarif 2022[Tarif monteur]) = Total

The “Tarif 2022[Tarif monteur]” portion is your problem. That returns a list of all [tarif monteur] values in the entire Tarif 2022 table. You need to select a single record from that table somehow. Perhaps you should be setting up a reference and using a dereference expression.

https://help.appsheet.com/en/articles/961426-references-between-tables

https://help.appsheet.com/en/articles/1090811-dereference-expressions

https://community.appsheet.com/t/referencing-a-column-value-in-a-table-versus-referencing-all-column-values-in-the-entire-table/50771

[anonymous]

Thank you very much !!
You have opened a door in my understanding of appsheet.