@creece i have.. i ended up creating 5 non-stored transaction body fields that each referred to a search that summed up the total balance for each respective period (maybe there is an easier way, I never found one though)

I figured there were some searches involved.. ill give it a go tomorrow... appreciate it