Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts
The following code works fine:
if([Product]<>'', Sum({<Month={'Aug'},Year={'2022'}>} [Quantity]), 0)
This formula doesn't work, any ideas?
if([Product]<>'', Sum({$<Month={"$(={month(today()))"},Year={"$(={year(today()))"}>} [Quantity]), 0)
Thank you, Tom
{$<Month={"$(=month(today()))"},Year={"$(=year(today()))"}>}
There's excess '{' in each of your formulas for month and year.
{$<Month={"$(=month(today()))"},Year={"$(=year(today()))"}>}
There's excess '{' in each of your formulas for month and year.