I have a formula field that compares a fields previous and next records and either returns 1 or 0 depending where the condition is true or false. Now I want to sum the formula field to give be a total at the group level.
How can I sum the formula field so I will have a total per group. I guess because I am using the next and previous functions in my formula, that it can't use sum on the same field. Is there some way using variables that I can create a counter.
Any help would be appreciated.
How can I sum the formula field so I will have a total per group. I guess because I am using the next and previous functions in my formula, that it can't use sum on the same field. Is there some way using variables that I can create a counter.
Any help would be appreciated.