4 Replies Latest reply: Oct 22, 2015 2:49 AM by Yeo Poh sai RSS

    How to insert eXCHANGE field into my SET analysis ?

    Yeo Poh sai

      Hi All


      I have using load script to create a field name eXP :-


      If([Reporting Code]>=100 and [Reporting Code]<=374,'eXP') as [eXP],


      And i make use of the expression to plot the eXP amount chart , it work fine :-




      Now i create another load script field name eXCHANGE :-


      If([Reporting Code]>=175 and [Reporting Code]<=175,'cXCHANGE') as [eXCHANGE],


      Now i like to insert eXCHANGE into below script :-




      I Try below , cannot work  :-