Hi,
I have dashboard with pivot widget where I have calculated field. When I export the pivot to excel (Functions - Export do aplikace Excel) the calculated field in excel file is empty:
Is it bug or did I miss to set something in the widget options?
Thanks,
Vera
It works correctly in my test example. The calculated array takes the value from the Number_2 array → the output of the calculated array is Number (please check this) and the result looks like this (see screenshot).
In my pivot I have one sum field (sums values Dohad měřák), one average field (pevna cena na pobočku) and one calculated as sum of sum(Dohad měřák) and avg(pevna cena na pobočku). “Plain” sums are ok, and I can see them in excel export but not the last field which is a sum of sum and avg column.
Did you try to add a computed field and set the formula in this editor? Does the export work for you?
This is probably related to the previous question. The combination of avg + sum is evaluated as a string. We’ll look into it and let you know.
