sum of Column.

[#1]

I have a column called Current with values as below.

           0

  6,494.00

39,253.00

   56,00.00

481,216.00

12,000.00

19,330.00

When I put sum(Current) in text box I get 7371516 as a return value where as the sum has to be in '$' amount  $614,293 .

Am I doing something wrong here ?

Thank you.@

[qlikviewwizard]

Hi,

Your total value is different from your sum.

Please check the below script and screens. Hope this will help you.

Data:

Load * inline [

SNo,Value

1,0

2,6494.00

3,39253.00

4,5600.00

5,481216.00

6,12000.00

7,19330.00

];

Output:

[HirisH_V7]

Hi,

Please use ,Expression Like this ,

    =Num(Sum(Column),'$#,##0.00;($#,##0.00)')

I Hope this helps .

Regards,

Hirish

[raman_rastogi]

you can change Number property of object to add $ sign.

[#5]

Thank you but I cannot see the logic in the link. What expression do you have in the text objcet ?

[qlikviewwizard]

This logic:

='Total =$' &num(sum(Value),'#,##0')