5 Replies Latest reply on Apr 11, 2016 2:15 PM by Christian Berg

    How to apply Sum on dollar values

    Manu

      How to apply Sum on dollar values

      i have data as

       

      c1     c2

      jan    $10

      feb    $20

       

      Both c1 and c2 are varchar datatypes, how can apply sum on c2 which is varchar

      since c2 is have $ sysmbol, im not able to cast this to integer

       

      Anyone help