FTE % to Total Straight table p. 336 in Qlikview for Devs book

[happyjoshua777]

Hello,

I have followed the steps to create a straight table in Qlikview 11 for Devs and ended up with very strange results (refer to table.png attached). I have also attached screen shot of relevant tabs, as well as the Edit Expressions panel.

I have also attached expected_result.png which displays the table one is meant to come up with.

May I ask you, where have I gone wrong?

thanks

[maxgro]

In the number tab, flag "Show in percent (%)"

[happyjoshua777]

I did that and now the total is 1,00% and the rest are very small numbers

[#4]

Can you select two decimals for the fixed to option and see that the format is #,##0.00% after selection of "Show in Percent(%)" option

[happyjoshua777]

I did that and now the results are even more ridiculous

ta