Appsheet Expression SUM Filter Data

[syahirISB]

Hi all, I have a question.

I have a filtered data like image below

I want to calculate total mileage based on filtered total mileage. Any suggestions how to create expressions for that?

[Aurelien]

Hi @syahirISB

What about that?

SUM([FILTERED_DATA[Total Mileage])

Where FILTERED_DATA is the name of the slice underlying the view on the right part of your screenshot.

For reference:

SUM() - AppSheet Help

[syahirISB]

woww…so simple yet efficient. it works!

never cross my mind to use slice in the expressions. thanks a lot. have a good day.

[Aurelien]

You are welcome, have a great day!