Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Or this
Sum({<Type = {'North', 'South'}, Operation_Date = {"$(=Max({<Sales = {
Maybe
Sum( {<Type = {'North','South'}, Sales = {'*'},Operation_Date = {"$(=Max(Operation_Date))"}>} >} Sales) ??
Or this
Sum({<Type = {'North', 'South'}, Operation_Date = {"$(=Max({<Sales = {