Sage Intelligence SubTotal circular references errors when using Dynamic Range Refresh function.

Question

I am using SubTotals in a large financial report using Dynamic Ranges, when I refresh the report I receive Circular reference errors. Note I manually fix the reference errors but they keep coming back when Refreshing the worksheet. Any ideas?

Gabriela Yates · Answer

When you create your subtotal, you need to input each dynamic range as it's own independent sum [use the excel function =SUM(H13:H16) and so on]. This is because the range will dynamically change, so if you capture the individual sum for that range and only that range, it will expand and contract appropriately. Therefore if I am doing a subtotal of everything above my subtotal cell, but it happens to contain 8 different dynamic ranges, my subtotal formula would be as follows: 
 =SUM(H13:H16)+SUM(H17:H17)+SUM(H18:H18)+SUM(H19:H19)+SUM(H21:H21)+SUM(H23:H26)+SUM(H28:H32)+SUM(H34:H34)

Sage 300

Sage Intelligence SubTotal circular references errors when using Dynamic Range Refresh function.

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING