Conditional expression number formatting

[#1]

Hi everyone,

My chart has a conditional expression, that is really two different expressions. The expression used depends on setting a variable elsewhere. It looks something like this:

=if(vExpression='Total Spending',num(sum(Amounts),'$#,###,###'),

if(vExpression='Inventory',sum(Inventory),

))

I have enabled Values on Data Points, and I want the values to be formatted as $ for sum(Amounts), and as number for sum(Inventory). As you can see, I have tried to set the formatting in the expression, and I have set Number Format Settings in the Number tab to 'Expression Default', but this has not worked. Does anyone know of a solution?

Thanks

[#2]

Hi

Did you ever manage to find a way to get this to work? I am having the same problem now and wondering if there is a way to sort it out.

Thanks