Number format £#,##0??

[cmccafferty]

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?

[fdelacal · Accepted solution]

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

[cmccafferty]

Legend!!!

[cmccafferty]

Legend!!!