Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
i have a pivot table on qvw,
PROJECT | TASK | =Num(aggr(SUM(ACTUAL),TASK),'0,00') | TIME | 2008 | 2009 | 2010 |
PROJECT2 | TASK2 | 2,33 | - | 3 | - | |
PROJECT2 | TASK3 | 3,84 | 1 | - | - | |
PROJECT2 | TASK4 | 4,32 | - | 3 | - | |
PROJECT2 | TASK5 | 1,88 | - | - | 3 |
when i export this object on excel, column =Num(aggr(SUM(ACTUAL),TASK),'0,00') is not in numeric format in excel. i would like export this column in numeric format and keep comma.
try '#.##0,00'
hi Fernando,
with that i obtain:
PROJECT | TASK | =Num(aggr(SUM(ACTUAL),TASK),'#.##0,00') | TIME | 2008 | 2009 | 2010 |
PROJECT2 | TASK2 | 2.##0,00 | - | 3 | - | |
PROJECT2 | TASK3 | 4.##0,00 | 1 | - | - | |
PROJECT2 | TASK4 | 4.##0,00 | - | 3 | - | |
PROJECT2 | TASK5 | 2.##0,00 | - | - | 3 |
excel understant it is a numeric because . but result is not i want. What means '#.##0,00'?