Slice to show next 90 days

[Neilemmo]

Hi, I have a slice for all renewals, I would like a slice to show me the renewals in the next 90 days but I’m obviously not doing it right.

All renewals expression:

[B&C Status]=B and C Renewals

Renewals in 90 days expression:

AND([B&C Status]=B and C Renewals,[Mortgage Renewal Date] <= (TODAY()+90), ISNOTBLANK([Mortgage Renewal Date]), [Mortgage Renewal Date]>=TODAY() )

Can someone please help me get this right.

[Steve]

Put quotes around B and C Renewals?

[B&C Status]="B and C Renewals"

See also:

help.appsheet.com

Text Expressions

Text expressions use and/or produce textual values.

[Neilemmo]

Tried it but still showing the same results as the first slice without the extra filters.

[Steve · Accepted solution]

Are you using a view that is configured to use this slice?

[Neilemmo]

It’s always something simple haha. Thanks for reminding me.