I created new View where i attempt to do calculation within APP. I have a couple of column in a certain table with numeric values.
To get the total (sum) value of particular rows, i generated simple table with single column. On Appsheet, i generated some virtual column and put math expression into App formula, something like this. “=SUM(Voyages for Combination[Ope P/L])/SUM(Voyages for Combination[Total Voyage Days])”.
Actually, I want to filter the row by a certain conditions to sum up rows.
Above expression is looking up all the rows in table, but is it possible to add filter to rule out the unnecessary rows in table before sum up column?
I created new slice, but we are not able to add this slice into Sum() expression, but only proper table can be looked up?