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