12 Replies Latest reply: Dec 18, 2017 2:38 AM by Yeo Poh sai RSS

    Expression work for 1 variable but not work for 2 variable

    Yeo Poh sai

      Hi All

       

      I have create a variable = Days

       

      and i insert the above variable to below expression , it work fine :-

       

      If(Sum({<SEGMENT -= {'Related Coy'},aging_ar = {'>=$(=vDay)'} >}total_ar  * 1) > 0,


      Sum({<SEGMENT -= {'Related Coy'},aging_ar = {'>=$(=vDay)'} >}total_ar  * 1))


      Due to i need to add one more variable , so i create one more variable = Days1


      and again i insert to my expression , but it cannot work.

       

      If(Sum({<SEGMENT -= {'Related Coy'},aging_ar = {'>=$(=vDay)''<=$(=vDay1')} >}total_ar  * 1) > 0,


      Sum({<SEGMENT -= {'Related Coy'},aging_ar = {'>=$(=vDay)''<=$(=vDay1)'} >}total_ar  * 1))


      Hope some one can share with me where i go wrong ?


      Paul