Expression for all existing Year(WBS)

[TomBond77]

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?

[BrunPierre · Accepted solution]

Try

Sum(Aggr(Sum({<[Year (Production)]={$(=max([Year (Production)]))}>} [# open]),Year (Production),Year(WBS)))

[TomBond77]

Many thanks, this works!

How should this formula must look like to get the correct result?

RangeSum(Above(Sum({<[Year (Production)]=>} [# open]), 0, RowNo()))

[BrunPierre]

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()))