Decimal Places in Chart Labels

[#1]

Hello!

Just getting into using Qlikview and have hit a funny hurdle.

Have created charts that display summed values in the labels but cannot get them to adhere to decimel places or seperators.

An example is;

='Value : £'&sum(if(wildmatch(product_range_desc,'*Fleet*'),dt_qty*dt_net_price,0))

What am i missing?

Can anyone assist?

Thanks

[#2]

Hi,

Maybe this would work:

='Value : £'& Num(sum(if(wildmatch(product_range_desc,'*Fleet*'),dt_qty*dt_net_price,0)),#.##0)

[#3]

thanks for your response.

It hasn't solved my issue. when i attempt to use the amended code it starts highlighting a numsum function along with claiming that the format information at the end is a bad field name(s).

Can you or anyone assist further?

Is there another approach we could take over using the num feature to achieve the formatting we're after?

Thanks

[#4]

There are a couple of ' missing at end of the expresion, where the number format. It should be:

='Value : £'& Num(sum(if(wildmatch(product_range_desc,'*Fleet*'),dt_qty*dt_net_price,0)),'#.##0')