4 Replies Latest reply: Oct 22, 2015 2:49 AM by PAUL YEO RSS

    How to insert eXCHANGE field into my SET analysis ?

    PAUL YEO

      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 :-

       

      Sum({<eXP={"eXP"}>}Amount)/1000

       

      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 :-

       

      Sum({<eXP={"eXP"}>}Amount)/1000

       

      I Try below , cannot work  :-

       

      Sum({<eXP={"eXP"},eXCHANGE='eXCHANGE'>}Amount)/1000

       

      Paul