Custom report calculation

V5 Question
1

Hello, I want to make a custom report, where under the total of the user a comission of 9 percent is calculated.
here is my code

` @{REPORT PAYMENT DETAILS:P.User,P.Amount.Sum::{0}:,}

[Settled by $1:1, 1, 1]

{REPORT PAYMENT DETAILS:P.Name,P.Amount.Percent,P.Amount.Sum:(PU=$1)}

Total Income|{REPORT PAYMENT DETAILS:P.Amount.Sum:(PU=$1)}

Comission|[=F(({REPORT PAYMENT DETAILS:P.Amount.Sum:(PU=$1)})*0.09)]`

here is the result:

I don^t get why the result is like that. Can you please help? Thanks.

2

You need to use a field calculation. I’m not where I can demonstrate but field calculations are demonstrated in our wiki page for custom reporting.

3

Your report worked fine for me but you may need to use TN function to ensure it handles numbers correctly.

@{REPORT PAYMENT DETAILS:P.User,P.Amount.Sum::{0}:,}
[Settled by $1:1, 1, 1]
{REPORT PAYMENT DETAILS:P.Name,P.Amount.Percent,P.Amount.Sum:(PU=$1)}
Total Income|{REPORT PAYMENT DETAILS:P.Amount.Sum:(PU=$1)}
Comission|[=F(TN("{REPORT PAYMENT DETAILS:P.Amount.Sum:(PU=$1)}")*0.09)]
4

Thanks a lot no now it works !