Whats the difference in the syntax? (Custom Report Tag)

Version 4 V4 Question
1

i had this tag used to calculate the rounding

Rounding:|$[=F(TN(‘{ACCOUNT TRANSACTION TOTAL:Rounding Transaction:Rounding}’)+TN(‘{ACCOUNT TRANSACTION TOTAL:Auto Round +}’)+TN(‘{ACCOUNT TRANSACTION TOTAL:Auto Round -}’))]

but this is giving different sum from the work period report

so i try this

Rounding:|$[=F(TN(‘{REPORT CALCULATION TOTAL:(CT=Auto Round +)}’),‘0.00’)]

now its giving the same result as the default work period report

my question is what is the difference in the two tag

2

Second one is pulling only from the calculation total. THe first one is a sum of Rounding account + the two auto round accounts. If you had anything inside any of those 3 accounts that were not part of the calculation then it would be off.

3

but the result should be the same

4

Show screenshot with those accounts? Also show screenshot of the report showing the calculation total.

5

Rounding:|$[=F(TN(‘{REPORT CALCULATION TOTAL:(CT=Auto Round +)}’),‘0.00’)]
Rounding:|$[=F(TN(‘{ACCOUNT TRANSACTION TOTAL:Rounding Transaction:Rounding}’)+TN(‘{ACCOUNT TRANSACTION TOTAL:Auto Round +}’)+TN(‘{ACCOUNT TRANSACTION TOTAL:Auto Round -}’))]

custom report:

work period report

6

Looks like its a syntax error. You actually have Auto Round + accounts and Auto Round accounts? I thought you put it all in just Rounding?

Show screenshot of the Manage screen setup of the account transactions?

7

d86269eae2718c87.png1366×768 106 KB

d2ccc6d70027002b.png1366×768 104 KB

8

Do you use the other rounding types? I thought you only rounded up and not down. Also do you use any other rounding?

9

ya i am hust rounding up no other rounding

10

So delete Auto round - account and switch your Auto Round + to just use rounding or delete Rounding… You only need 1 transaction type. And that would make your expression easier and more accurate.

1 Like
11

delete the account type or in report

12

Why have the account type if its not used?

13

i have deleted the round - account but it made no difference

so if i use the calculation total tag is that enough

14

Yes its enough. If you remove that account then you would remove it in your syntax as well. Your getting 0 because its bad syntax something is wrong. Its not returning a value.

15

no use still getting 0

16

I think the problem is:

{ACCOUNT TRANSACTION TOTAL:Rounding Transaction:Rounding}

Your not actually using Rounding

You should probably use the Calculation expression anyway its going to always be right and not affected by accidently linking other transactions into an account.

17

i haave try this also

Rounding:|$[=F((TN(’{ACCOUNT TRANSACTION TOTAL:Auto Round +:Rounding}’)),’#,#0.00’)]
Rounding:|$[=F((TN(’{ACCOUNT TRANSACTION TOTAL:Rounding Transaction:Rounding}’)),’#,#0.00’)]

result 0

18

It should be [=F(TN('{ACCOUNT TRANSACTION TOTAL:Auto Round +:Rounding}'),'#.#0.00')]

Although I could be wrong but #.#0.00 looks strange to me what does this do?

19

this is what i am getting now

Rounding:|$[=F(TN(‘{REPORT CALCULATION TOTAL:(CT=Auto Round +)}’),‘0.00’)]
Rounding:|$[=F(TN(‘{ACCOUNT TRANSACTION TOTAL:Auto Round +:Rounding}’),‘#.#0.00’)]
Rounding:|$[=F((TN(‘{ACCOUNT TRANSACTION TOTAL:Rounding Transaction:Rounding}’)),‘#,#0.00’)]

a difference again

20

Bottom one is correct because your not using it… it will be 0

middle one is correct because you told it to convert the 5 from 0.15 to a 0

Try this:

Rounding:|$[=F(TN('{ACCOUNT TRANSACTION TOTAL:Auto Round +:Rounding}'),'0.00')]