Total function in the table properties

[anuhegde]

Greetings to all!!

In the straight table properties, total function is set to auto.

In that table,there is only one row and the values in this row and the totals row is different. Is this beacuse of auto? what might be the reason for this?

The expectation is to get the same values in the totals row as the below row.

Attached the screenshot for the better understanding.

[zebhashmi]

Yah should not be that. what is your expression for this?

[OmarBenSalem]

you can control the total expression by using the dimensionality() function.

In fact, try to change ur expression as follow:

if(dimensionality()=0, NewExpressionForYourTotals, YourExpression)

please refer to this:

How to use - Dimensionality()