I'm a fairly new user of Board, so this might be something obvious - I've been building financial reports, but with my percentage calculations, through using rules, the percentages are correct on the data columns, but incorrect on both the total columns/rows. Values are all divided by 1000 to get $'000 for my financial reports. My percentages on the total column/rows are all multiplied by 1000 in error. I can't seem to only apply or not apply to totals, or create a separate rule, which doesn't seem correct.
Could someone advise what setting I'm missing to get the total column/row percentages working with the same formula as the data rows?