PBCS Report Formulas Not Updating When Rows Are Inserted or Deleted

Hello,

I am experiencing an issue with a report in PBCS.

Some rows contain formulas that reference other rows by row number. For example:

[4] + [6]

The problem is that when I insert or delete rows, these formulas do not automatically adjust to the new row numbering.

For example:

• Original formula: [4] + [6]
• I insert a new row between rows 1 and 2.
• The referenced rows should shift accordingly, but the formula remains [4] + [6].
• As a result, the formula points to the wrong rows and the calculation no longer makes sense.

I would expect the row references to be updated automatically when rows are added or removed, similar to how formulas behave in spreadsheets (and how it works in other reports).