Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Try,
Load
If( VATIndicator = 'A', SalesValue, 0) as SalesValueA,
If( VATIndicator = 'B', SalesValue, 0) as SalesValueB,
If( VATIndicator = 'C', SalesValue, 0) as SalesValueC
From ..
Jay
Try,
Load
If( VATIndicator = 'A', SalesValue, 0) as SalesValueA,
If( VATIndicator = 'B', SalesValue, 0) as SalesValueB,
If( VATIndicator = 'C', SalesValue, 0) as SalesValueC
From ..
Jay