Multiply two field in matrix

igorfv

Hi my friends,

How do multiply two fields in the matrix with the logic below? Give me a sample, please.

The logic for column 1 and row 1 - SPAG1:

The logic for column 1 and row 2 - SPAG1:

The logic for column 2 and row 1 - SPAG2:

The logic for column 2 and row 2 - SPAG2:

Thanks!

Igor Valle

SPAG_LOGIC.xlsx

MeganBowers

Hi @igorfv , see the attached solution, which makes use of the filter, append, and formula tools in order to generate column D and E in your spreadsheet

workflow_1.yxmd