Why does a SUM rounding occur that does not happen in the Average?
I wish there were no rounding.

Someone ?

Could you please set

$field = new PivotAverageField ("field_name");
$field->DecimalNumber = 0;

I want see decimals ...
I believe that is so :
$field = new PivotAverageField ("field_name");
$field->DecimalNumber = 2;
Right ?

Are there someway to format with my regional settings ?
Tks so much

Use you the FormatString property:

$field->FormatString = "EUR {n}"; //For example

But what about exchanging commas for points and vice versa?

$field->DecimalPoint = ".";
$field->ThousandSeperate = ",";

You may try this codegen http://codegen.koolphp.net/pivot_table/

Tks so much !

But it is not all right ...
when we close a level of grid the grand total and open the level again ... the aggregation that is a average type so ... change to sum aggregation type...
Before

After

The metric show with description Average Grand Total and in font is
$field = new PivotAverageField("PRECO_CUSTO");
$field->DecimalNumber = 2;
$field->Text = "Preço de Custo - Medio";
$field->FormatString = "R$ {n}"; //For example
$field->DecimalPoint = ",";
$field->ThousandSeperate = ".";
$field->AllowReorder = false;
$pivot->AddDataField($field);
And the calculations show a SUM Value not an Average Value.

We will check on this issue and come back to you as soon as possible.

When will I have the answer? Because I need to finish my project.

Hi, how are you ?
Good Day for you.
I´m Waiting for the FIX.
Tks so much.

Hi Carlos,
We have sent an updated version to you via ticket support. Please try it and let us know it's good for you. Thanks!

The solution is not totally ok yet.
There is a problem in Grand Total of Average ...
See attached pictures.
I have not even tested MAX and MIN ... are you OK with these groupings?

Hi Carlos,
Is there something wrong with the grand totals of average? Please remember they are not an average of individual Canal or Hierarquia, etc but the average of individual rows in the database.
Those grand totals are computed using sql query and AVG operator. You could run a direct sql query in your database interface to check those values. Please let us know the result. Thanks!

You are right ! Tks !