row filter condition for a slice.

[anonymous]

My app has a “Balance” table. This balance table gets data from the other two tables “Income” and “Expenses”.

Below is the main Balance table, with this I created a slice Balance 2

This is the “Balance 2”. Slice function: DATE([Date])= Date(TODAY())

• The problem is, I am unable to get those highlighted values(Income, expense, balance) when a row is filtered. Those three values are generated from the dataset. And this is how the data look in sheets.

Please help. Thank you.

[SkrOYC]

@swetha27

Slice function: DATE([Date])= Date(TODAY())

No need for DATE(), just:

[DATE]=TODAY()

@swetha27

I am unable to get those highlighted values(Income, expense, balance) when a row is filtered

OR(
 [_THISROW]="BALANCE",
 [DATE]=TODAY()
)

[anonymous]

It worked, Thank you. But how do I sum the values by today?

[SkrOYC]

Idk, it depends on how your “Balance” row is working.
AppSheet doesn’t support totals so it’s a workaround you made

[anonymous]

Balance row works by: sum of income - sum of expenses + sumif expense is “hold”.

[SkrOYC]

Sure, but those are AppSheet expressions? It seems you are doing this inside your worksheet, so don’t expect it to behave different based on the slices you make inside the App