?

[xyz1]

.

[xyz1]

/.

[sunny_talwar]

Looks good... is it not working for you?

[xyz1]

x

[sunny_talwar]

You are saying we are in March? Are we really in March? I am not sure I understand how can we be in March when it is only January? I am not sure I follow what is incorrect here.

[xyz1]

a

[sunny_talwar]

Can you just provide me the numerical output you are looking to get in a Excel file? I understand the logic, but I am not sure what isn't working.

[xyz1]

z

[sunny_talwar · Accepted solution]

Try this

RangeSum(Above(If(Month(Months) <= Month(Today()), (Sum({$<[type]={'Actual GFC'}>} value)), (sum({$<[type]={'Forecast GFC'}>} value))), 0, RowNo()))

RangeSum(Above(If(Month(Months) <= Month(Today()), (Sum({$<[type]={'Actual CAPEX'}>} value)), (Sum({$<[type]={'Forecast CAPEX'}>} value))), 0, RowNo()))

So, instead of rangesumming the individual expression, rangesum the whole if statement