6 Replies Latest reply: May 22, 2014 4:18 PM by Toni Kautto RSS

    Set Analysis with ' sign

      Hi all,

       

      Im trying to write a set analysis with a string value containing ' in it.

       

      I want it to look like this :

       

      =sum({<[BSHeading]={'NCA - dep'n'},[QuarterFiscal]={'Q1'}>} Amount)/1000000)

       

      but the ' sign is causing the problem for quotation marks.

       

      So I tried the below instead :

       

      =sum({$<CFHeading={$(=     NCA - dep'n)},[QuarterFiscal]={'Q1'}>} Amount)/1000000

       

      but it does not swon other than 0

       

      If someone has a solution here, I would be very happy!

       

      PS. It could be very useful to know how to handle ' in if clauses as well! DS.

       

      Best Regards

       

      Calle