Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=sum(
if(
aggr(sum({<[Control Description]={"Policy New Business", "Policy Cancellations"},
[Fiscal Year Month] = date(addmonths(today(), -1), 'YYYY-MM') >}
[Record Count]),
Country)=0,
1,0)) > 0
Can anyone see what is wrong with this code above? I want to say [Fiscal Year Month] = last month (2016-10)
You may forget $
=sum(
if(
aggr(sum({<[Control Description]={'Policy New Business', 'Policy Cancellations'},
[Fiscal Year Month] = {"$(=date(addmonths(today(), -1), 'YYYY-MM'))"}>}[Record Count]),Country)=0,1,0)) > 0
May be try this
=sum(
if(
aggr(sum({<[Control Description]={'Policy New Business', 'Policy Cancellations'},
[Fiscal Year Month] = {"=date(addmonths(today(), -1), 'YYYY-MM')"} >}[Record Count]),Country)=0,1,0)) > 0
You may forget $
=sum(
if(
aggr(sum({<[Control Description]={'Policy New Business', 'Policy Cancellations'},
[Fiscal Year Month] = {"$(=date(addmonths(today(), -1), 'YYYY-MM'))"}>}[Record Count]),Country)=0,1,0)) > 0