Forum Discussion
There are typically 3 ways member formulas or BRs can write calculations simplistically:
- api.Data.Calculate("A#YourAccount = RemoveNoData(A#" & accountName & ")")
- api.Data.Calculate("A#YourAccount = RemoveZeros(A#" & accountName & ")")
- api.Data.Calculate("A#YourAccount = (A#" & accountName & ")")
The first way only removes true no data cells. Sometimes you may need this if you need a zero picked up when calculations run.
The second way will remove no data but also remove zero values from things on the right hand side of the "=". This is probably the most common and recommended but again, there can be times when you do not want to exclude zeros so need to use the first way.
The third way is almost never recommended as it does not remove either no data or zeros meaning it will run on every possible combination of elements to the right of the "=" and can explode your data unit.
It sounds like your calculation may have been written with #2 and you may need to switch it to #1. In a DEV app you could find and change the RemoveZeros to RemoveNoData and see if that resolves your issue. This may impact more than one calculation and may also impact historical results by changing it, depending on the formula. So, I would recommend testing in a DEV app first.
Related Content
- 2 months ago
- 10 months ago
- 2 years ago