Data Display

Giselle100 — Sat, 16 Nov 2024 07:14:32 GMT

I have built an app and upon opening the app, no data displays.

These are my expressions:

Variables

vMaxYear=if(getselectedcount(Year)=0, max({<CurrentYear = {1}>}Year),max(Year))

vMinYear=MIN("Year")

Expressions

Refund Units TY = sum({<Year={$(vMaxYear)}>} [Refund Qty])

Refund Units LY = sum({<Year={$(vMaxYear)}-1>} [Refund Qty])

My data goes all the way up to 2021 which does not have data hence the TY has no values as we not there yet.

How do I restrict my data to display where we currently are today?

We also have a field calendar type (which has two calendars planning and financial). How do I restrict the data to display where we currently at in above-mentioned calendars?

topic Data Display in App Development

Data Display