The 1st formula is for the overlimit in dollars, the 2nd is for the %. Both can only be calculated after the report has its totals, so I'm guessing that may be the reason. But please tell me if there's a workaround. Thanks!
If Sum ({OPEN_ITEMS.OI_OPENAMOUNT}...
I have created a formula of 'overlimits' in a report (open a/r - credit limit). I want to group/sort in descending order to view the biggest customers first. However, when I use the group or sort function, my formula isn't listed as an option to select from. I'm using 7.0.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.