Data format

[Anonymous]

I have a staright table with measures as sales and quantity and have two buttons for selection(sales and quantity).

On clicking sales button it will display the sales values and on clicking the quantity button it will dispaly quantity related values.

My requirement is when i will click on sales button it should show me the vlaues in price format and the quantity values in number format.

Can anyone please help me on this ?

[alexandros17]

when you display the quantity values e.g. sum(qtyValues) write:

Num(sum(qtyValues), '#.##0')

and with prices:

Num(Sum(price), '€ #.##0,00;-€ #.##0,00')

[anbu1984]

In Chart Properties (Number --> Expression), Select number format settings

[SunilChauhan]

In expression itself you can apply formats

using NUM function

like Num(FieldName,'$#') for ineteger whith $

like Num(FieldName,'$#.00') for decimal whith $

like Num(FieldName,'$#,##.00') for decimal whith $

for thousand seperator and decimal and $

you can also take money format using number(properties-> number-> money) see and apply using text box

hope this helps

[Anonymous]

have changed the format to money and number..but its not working.

[SunilChauhan]

can you please attached the sample

[Anonymous]

Try like this

In the Script create a variable

Let vSum=Num(sum(qtyValues), '#.##0');

Let vPrice=Num(Sum(price), '€ #.##0,00;-€ #.##0,00');

[Anonymous]

[SunilChauhan]

can you give example which format you want your numbers/amount

[Anonymous]

For value i need in money format and for volume its like number format.