I have a list of accounts and sub-accounts that flow into the Finance/Admin line item on the FS. It is accounts 63000 to 71300 (sub account 700-000) as well as accounts 72300 to 72303 (sub account 000-000).
How can I set up the Data Source in Row Sets to include both of these in the same line?
Best answer by BenjaminCrisman
Hi @jwarren ! I’m not the greatest with ARM reports but I would think if you set the start sub of 000000 and end sub of 700000 it should capture all that (and maybe more in between which you didn’t want!).
If that can’t work have you tried adding a second line with the second account/subaccount range and adding it to the first line?
Hi @jwarren ! I’m not the greatest with ARM reports but I would think if you set the start sub of 000000 and end sub of 700000 it should capture all that (and maybe more in between which you didn’t want!).
If that can’t work have you tried adding a second line with the second account/subaccount range and adding it to the first line?
Hi @jwarren ! I’m not the greatest with ARM reports but I would think if you set the start sub of 000000 and end sub of 700000 it should capture all that (and maybe more in between which you didn’t want!).
If that can’t work have you tried adding a second line with the second account/subaccount range and adding it to the first line?
Hi Benjamin,
You are correct that setting start sub as 000000 will result in including way more subaccounts than we are needing.
I’ve created a second line and would like to sum these so it only shows 1 line. Right now I’m stuck with two lines on my report.
Hi @jwarren ! I’m not the greatest with ARM reports but I would think if you set the start sub of 000000 and end sub of 700000 it should capture all that (and maybe more in between which you didn’t want!).
If that can’t work have you tried adding a second line with the second account/subaccount range and adding it to the first line?
I’ve created a third row that totals the two above & under Printing Control, I have set it to Hidden on first two rows so it only shows the Total.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.