Set Analysis not working as expected

[Analyst240]

Currently using the following expression to try and create a static value for a table to only show a single day of data.

Field names are different for the sake of privacy.

=sum({<MYCUSTOMDATE={"=date(Today()-1)"}>}MARBLECOUNTFIELD)

The table has 3 fields. Date, Marble count, and location. 

The plan is to show all marble counts for each location yesterday. 

But using the expression above gives all marble counts for all locations for all time periods. Until filtered on manually. We need the count to show yesterday's values only and not change when the user filters and selects data elsewhere. This will be used in a Nprinting report so having it preset for Nprinting to send out will be vital.

Happy to take any thoughts/questions

Thanks,

Analyst

[Vegar]

Try this (assuming that your default date format is  in the same format as MYCUSTOMDATE):

=sum({<MYCUSTOMDATE={'$(=DayName(Today(),-1))' }>}MARBLECOUNTFIELD)

[aveeeeeee7en]

Hi Analyst240,

Today()-1 will give you DD-MM-YYYY Format. So, make sure your Date Field (MYCUSTOMDATE) must be in that Format.

Use this Code:

=Sum({1<MYCUSTOMDATE= {'$(=Date(Today() - 1))'}>} MARBLECOUNTFIELD)

See the Final Result:

Desired Output

Regards,

Av7eN