I created new View where i attempt to do calc...

(tsuji koichi) #1

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?

(Aleksi Alkio) #2

You should use SELECT expression instead of TableName[ColumnName]. Something like SUM(SELECT(Voyages for Combination[Ope P4L],[Value]>100))/SUM… You can write many different evaluations inside that SELECT expression if needed.

(tsuji koichi) #3

Thanks Aleksi, I will try with this expression and will see.