Problem with totals

[francisvandergr]

Ha,

Can someone help me ? I have buid in a formule in a amount field. When i do that my total is not good. Can someone help me so the total is the real sum of the shown values.

I have attaches an example

Gr

Francis

[#2 · Accepted solution]

Just change in the total mode (properties/expressions) : use sum of rows

jj

[francisvandergr]

Thanks for your reaction. I saw that option. The problem is i can't choose that option in my real database. In my example indeed i can use that option. Do you know a reason when that option is inactive ?

Gr

Francis

[francisvandergr]

I found it. The difference is straight table or pivot table.

[francisvandergr]

I found it. The difference is straight table or pivot table.

[spividori]

Hi.

As you answer the item, you solved it.

But, I leave the example as I do in the script and the simple table.

Regards.

[#7]

How to solve this problem if its a pivot table?