Announcements
You can succeed best and quickest by helping others to succeed. Join the conversation.
cancel
Showing results for
Did you mean:  Creator III

## ?

.

1 Solution

Accepted Solutions  MVP

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 8 Replies  Creator III
Author

/.  MVP

Looks good... is it not working for you?  Creator III
Author

x  MVP

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.  Creator III
Author

a  MVP

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.  Creator III
Author

z  MVP

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  Community Browser