I have 8 columns in my saved search results each of which consists of a fairly large formula (round, case, etc.).
I am trying to create a 9th column which would be a row total. I see an option for totals in the results but that just gives automatic column totals.
Unless there is something I'm missing there is no way to sum the row unless I sum each of my formulas together, ie (formula 1)+(formula 2), etc.
When I enter this formula in the results section I get an error that the formula is 760 characters too long, BUT, I'm able to save the search with this formula and it runs just fine for a little while.
After a while though the formula stops working and gets truncated and stops working, usually after I switch over to another browser or log off and back on again.
Does anyone have any advice on how to get a long formula to work OR how to sum rows?
Thanks,