2 Replies Latest reply: Aug 7, 2017 7:51 AM by Sara Titmuss RSS

    Expression help

    Sara Titmuss

      Hi,

       

      I have a bit of a silly question but can't seem to get it working:

       

      I have the following expression I want to use as a text object:

       

      =sum({<FINMONTH = {'>$(=max(FINMONTH)-max(FINMONTH)) <= $(=max(FINMONTH))'}, FINYEAR = {'$(=MAX(FINYEAR))'}>}SALES)+sum({<FINMONTH = {'>$(=max(FINMONTH)-max(FINMONTH)) <= $(=max(FINMONTH))'}, FINYEAR = {'$(=MAX(FINYEAR))'}>}ENDOEXTRA)

       

       

      I know to make it show in monetary value I need to add ,'£#,##0'' to the expression.  However, when adding it to the end it's not working:

       

      =sum(({<FINMONTH = {'>$(=max(FINMONTH)-max(FINMONTH)) <= $(=max(FINMONTH))'}, FINYEAR = {'$(=MAX(FINYEAR))'}>}SALES)+sum({<FINMONTH = {'>$(=max(FINMONTH)-max(FINMONTH)) <= $(=max(FINMONTH))'}, FINYEAR = {'$(=MAX(FINYEAR))'}>}ENDOEXTRA) ,'£#,##0'')

       

       

      Any advice?