Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have an equation that I am trying to figure out.
The below equation should equate to 1 (TRUE).
At the moment I am getting 0.
Any ideas?
Sum(
If(
Aggr(
Sum({<[Control Description] = {'Policy New Business'},
[Fiscal Year Month] = {"$(=Date(vMonthlyEnd, 'YYYY-MM'))"}>}
//{"$(=Date(AddMonths(Max(vMonthlyEnd), -1), 'YYYY-MM'))"}>}
[Record Count]),
Country) = 0,
1, 0))
where vMonthlyEnd is :
Let vMonthlyEnd = num(MonthStart(AddMonths(Today(), -1))); // Last Month
Hi!
try to use
Sum(
If(
Aggr(
Sum({<[Control Description] = {'Policy New Business'},
[Fiscal Year Month] = {"$(=Date($(vMonthlyEnd), 'YYYY-MM'))"}>}
[Record Count]),
Country) = 0,
1, 0))
Hi!
try to use
Sum(
If(
Aggr(
Sum({<[Control Description] = {'Policy New Business'},
[Fiscal Year Month] = {"$(=Date($(vMonthlyEnd), 'YYYY-MM'))"}>}
[Record Count]),
Country) = 0,
1, 0))
If what Tatsiana provided did not work, would you be able to share a sample?
This works a charm.
Thank you.