Hello,
I am trying to add one additional condition to this statement below, but can't seem to figure it out.
Here's what I have currently (which works):
=IF($[Row Identifier - Budget]@row = "Parent", SUMIF(CHILDREN([Alt Cost Center]@row), "", CHILDREN()), "")
And I'd like to add an additional option that says if [Alt FY]@row has data in it, to also follow the same protocol. They both do not need to be true, just one or the other.
Here's my work in progress...any help is much appreciated!
=IF($[Row Identifier - Budget]@row = "Parent", SUMIFS(CHILDREN([Alt Cost Center]@row, "", OR[Alt FY]@row)), "", CHILDREN())