How can I use the calculate formula using two filters of different columns?
First of all, thanks for the help. What I want is to add all those amounts that make up "Sueldos y Salarios" (Wages, Comision, Goals, etc) that are in one column but that do not take what are indeminzations, which is within "Saldos y Salarios" but with another breakdown in another column.
Formula that I am currently using and that indeminzations are included:
The breakdown of indeminations is as follows:
How can I continue to add all the concepts of "Salarios and Sueldos" except those that are "1.3 Indemnizaciones"
You can use the conditional column button under add column. Just create a new column where if your categorization column indicates exclusion, put null or 0, otherwise the value of the column you want to sum. Then just sum that new column.