Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts
A table with two different dimensions on year: Year(Production) and Year(WBS). The formula is as follows: Sum({<[Year (Production)]={$(=max([Year (Production)]))}>} [# open])
The result in the table is correct. If you remove the column for Year(WBS) the result changes to 5 which is incorrect. How do you modify above formula to get the correct result independent of a column Year(WBS) in the table?
Try
Sum(Aggr(Sum({<[Year (Production)]={$(=max([Year (Production)]))}>} [# open]),Year (Production),Year(WBS)))
Try
Sum(Aggr(Sum({<[Year (Production)]={$(=max([Year (Production)]))}>} [# open]),Year (Production),Year(WBS)))
Many thanks, this works!
How should this formula must look like to get the correct result?
RangeSum(Above(Sum({<[Year (Production)]=>} [# open]), 0, RowNo()))
What do you want to achieve?
I believe the Year(Production) in the expression should not be a function but rather a field name
In the script, create
Year(Production) as [Production Year]
and apply as below
RangeSum(Above(Sum({<[Production Year]=>} [# open]), 0, RowNo()))