I'm guessing this is in the macros part of the collections tab... I'm also guessing when you first put it in there you had appropriately encoded the | and } of the 'previous total' query. With collections macros, if you ever open them again and they contained html entities they will resolve to the appropriate character and therefore break the nesting... it's a pain point that has never been addressed sadly. Your options are to store a copy of your working macro offsite to copy/paste whenever you open that macro up or store the macro as an ability on a sheet. These don't suffer from the same issue. Long story short: ?{Previous Total|0} Needs to be replaced with: ?{Previous Total|0}