1 Reply Latest reply: Aug 10, 2011 8:33 AM by James Edgson RSS

    Where function in script

    Chris Hopkins

      Hi,I am writing a VAT application and  i am trying to break down a SalesValue field in my script

      E.g.

       

      Sales Value =£1000 which is a total of £200 Vat Code A, £400 Vat Code B and £400 Vat Code C

       

      I want to break this down in the script and make new fields something like:

       

      Load...

      SalesValue Where VATIndicator ='A' AS SalesValueA,

      SalesValue Where VATIndicator ='B' AS SalesValueB,

      SalesValue Where VATIndicator ='C' AS SalesValueC

       

      From...

       

      But i do not know how to do it..

       

      I know i can use set analysis in a chart to total up each VAT Code but i thought it might be quicker to get it done in the script instead (As the script is reloaded out of hours)

       

      Can anyone help please?