Set Analysis: Max Date for Sales not Null

[microwin88x]

Hello,

I have the following expression with set analysis:

Sum( {<Type = {'North','South'}, Operation_Date = {"$(=Max(Operation_Date))"}>} >} Sales)

This is to get the Sum of Sales for the Max Operation_Date.

The issue with the expression is that the Max Operation_Date could have null values for Sales.

That's why I need to modify the Max(Operation_Date) to get the Max Operation_Date where Sales are not null.

Do you know how could I do that?

Thank you!

[MK9885]

Maybe

Sum( {<Type = {'North','South'}, Sales = {'*'},Operation_Date = {"$(=Max(Operation_Date))"}>} >} Sales) ??

[sunny_talwar · Accepted solution]

Or this

Sum({<Type = {'North', 'South'}, Operation_Date = {"$(=Max({<Sales = {

}>} Operation_Date))"}>} Sales)