Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Friends,
I have a table that shows cost per month by account. The MTD column shown below is behaving correctly, i.e., it responds to the selections. However, the YTD column is calculating properly, but will show for omitted selections. YTD expression is below. Any help would be most appreciated. Thanks in advance!
=sum( {$<[MonthID] = {"<=$(=max(MonthID))"}>} [Actual])
Two options
1)
=Sum({$<[MonthID] = {"<=$(=max(MonthID))"}>} [Actual]) * Avg(1)
2)
=If(Sum(Actual) > 0, Sum({$<[MonthID] = {"<=$(=max(MonthID))"}>} [Actual]))
I'm unclear what you mean, but maybe you want this - the intersection of the MonthID selections and your set expression.
sum({<[MonthID]*={"<=$(=max(MonthID))"}>} [Actual])