SAS VA 8.3 MAXIFS

RadDaddo · Posted 09-12-2019 01:40 PM

Hi,

Does anyone know how to create a calculation within SAS Visual Analytics that results in a "MAXIFS" function (c.f. Excel)? For instance, the maximum date if/ when a minimum number/ threshold of transactions is completed. I also need to be able to filter by this date. In some cases, I also need to do the same but for week # instead of date.

Thank-you,

Leslie

TeriPatsilaras · Posted 09-13-2019 12:38 PM

Hi Leslie,

It sounds like you are running into our nested aggregated measure limitation. Check out my blogs on how to use an aggregated data source to work around this:

VA 8.3 Aggregated Data Source, an answer to nested aggregated measures and faster reports!

VA Report Example: Number of Days Profitable for the last 30 days

Thank you,

Teri

Teri Patsilaras is a Senior Manager in the Global Enablement and Learning (GEL) Team within SAS R&D's Technology Transfer and Governance Division