Discussions
Workaround for length of formula
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.