row filter condition for a slice.

[swetha27]

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())

even if i get the balance amount, it's not accurate and giving negative values.

• 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 · Accepted solution]

---

@swetha27 wrote:

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

---

No need for DATE(), just:

[DATE]=TODAY()

---

@swetha27 wrote:

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

---

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

[swetha27]

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

[swetha27]

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