topic Number format £#,##0?? in QlikView

Number format £#,##0??

cmccafferty — Fri, 12 Jul 2013 14:26:38 GMT

I’ve got this formula in QV to work out the overall fixed costs:

='Fixed Costs : ' &
((

num(max ({< [TPGP PricingTypeDescription] = {'Single'},[TPGC Costtype] = {'Per Tour'}>} [TPGP Cost PP]), '£#,##0', '.' , ',' ))
+
(num(max ({< [TPGP PricingTypeDescription] = {'Twin'},[TPGC Costtype] = {'Per Tour'}>} [TPGP Cost PP]

), '£#,##0', '.' , ',' )))

The formula seems to work and is picking up the expected result, however, it's not coming out in my desired format.

Any advice?

Re: Number format £#,##0??

fdelacal — Fri, 12 Jul 2013 14:33:32 GMT

try

='Fixed Costs : ' &

num(

(max ({< [TPGP PricingTypeDescription] = {'Single'},[TPGC Costtype] = {'Per Tour'}>} [TPGP Cost PP]))
+
(max ({< [TPGP PricingTypeDescription] = {'Twin'},[TPGC Costtype] = {'Per Tour'}>} [TPGP Cost PP]))

, '£#,##0', '.' , ',' )

hope that helps

Re: Number format £#,##0??

cmccafferty — Fri, 12 Jul 2013 14:40:26 GMT

Legend!!!

Re: Number format £#,##0??

cmccafferty — Fri, 12 Jul 2013 14:40:31 GMT

Legend!!!