I am trying to sort a report based on a calculation of 2 similar yet different formulas. Basically, I have a g/l account divided by a budgeted amount and I want use that as my primary sort column (The g/l account is a not the same as the budgeted one). In a similar report, I have a balance sheet amount divided by an income statement amount that needs to be my sort key. I figured since I keep coming across this same sorting limitation I better ask for help instead of continuing to manually sort every time I run them. I also figure if I can report against an account schedule with the calculation built in that would be awesome - is that possible?
Here are examples of column layouts:
Global dimension 1 name
g/l balance (account # a)
budget balance (account # b)
calc field (g/l balance / budget balance) **sort column
Thanks!
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi,
In Jet, sorting is done when replicating rows, so all sorts have to be defined in the NL(Rows) formula (or NL(Columns) or NL(Sheets) if you are replicating those). In order to sort by a calculation, you have to use a calc filter field in your NL(Rows) formula. What this looks like depends on what table you are replicating rows from and what fields are being used in your calculation. What does your NL formula look like and what do the formulas for G/L Balance and Budget Balance look like?
Regards,
Hughes
Please sign in to leave a comment.