Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Could someone please help me to understand why the first expression returns cumulative figures, whilst the second does not (only the exclusion parameter has been removed).
Count(DISTINCT{$<CCMonthID = {"<=$(=Max(CCMonthID))"},CCYear=,CCQuarter =,CCMonth = ,[CustomerID]=P({<[C delete label]={''}> + <DeleteMonthID = {">$(=Max(CCMonthID))"}>}),[ CustomerID]=E({<Addr={''}> * <[PostCode]={''}>})>}[ CustomerID])
Count(DISTINCT{$<CCMonthID = {"<=$(=Max(CCMonthID))"},CCYear=,CCQuarter =,CCMonth = ,[CustomerID]=P({<[C delete label]={''}> + <DeleteMonthID = {">$(=Max(CCMonthID))"}>})[ CustomerID])
Thank you.
Difficult to answer without looking your sample data.
You may be sure, that set of rows in first expression is not less than in 2'nd expression, because E() forces rows with Addr and PostCode = ' '. Those rows are not present (because they are excluded) in 2'nd expression.
1)
<DeleteMonthID = {">$(=Max(CCMonthID))"}>}),[ CustomerID]=E({<Addr={''}> * <[PostCode]={''}>})>
2)
<DeleteMonthID = {">$(=Max(CCMonthID))"}>
regards
Darek