I have a next problem
The format percent don't show correctly in the grid for example, the value is 0.6 and it should show 60% but only show 0.06% but in the moment of export to excel show 60%
My xml is
<measures>
<measure format="percent" aggregation="Average" caption="% de avance">[Measures].[Avance]</measure>
<measure format="percent" aggregation="Average" caption="% de cumplimiento">[Measures].[Cumplimiento]</measure>
</measures>
</defaultSlice>
<format name="percent">
<param name="thousandsSeparator">,</param>
<param name="decimalSeparator">.</param>
<param name="decimalPlaces">2</param> <!-- by default is -1. -1 means no formatting -->
<param name="maxSymbols">20</param> <!-- max number of symbols in cell. by default is 20. -->
<param name="currencySymbol">%</param> <!-- if you want format numbers as currency -->
<param name="currencySymbolAlign">right</param> <!-- left or right / by default is left -->
<param name="nullValue"></param>
</format>
My file csv is
Departamento,Provincia,Distrito,Centropoblado,CodigoModular,Institucioneducativa,Equipamiento,CanProgramada,CanRecibida,Cumplimiento
LIMA,CALLAO,CALLAO,CALLAO,0209304,"4001 DOS DE MAYO","Computadora Servidor + Monitor",1,1,1
LIMA,CALLAO,CALLAO,CALLAO,0209304,"4001 DOS DE MAYO","Laptop en Aula Funcional (AF).",2,2,1
LIMA,CALLAO,CALLAO,CALLAO,0209304,"4001 DOS DE MAYO","Laptop Educativa para estudiante",34,34,1
LIMA,CALLAO,CALLAO,CALLAO,0209304,"4001 DOS DE MAYO","Proyector Multimedia",2,2,1
And attach my screens.
Please help me!
Hi Oscar,
Yes, we have different implementation of this feature and unlike Excel don't convert numbers. Please find the workaround here: https://jsfiddle.net/flexmonster/s1p9ymx3/2/
Does it help?
Dmytro
I tried your link https://jsfiddle.net/flexmonster/s1p9ymx3/2/ but when i exported to excel it show me the same problem (2200%) and the correct value is 22%.
Help Me!!!
Hi Oscar,
Thank you for your feedback. We have reproduced the issue and will be ready with fix in the version 2.223 ETA(Oct10).
Best regards,
Dmytro.