how do i perform subtraction

Sat, 27 Feb 2016 14:56:46 GMT

Find attached.

I wanna subtract but I tem and place in new item called Total1

Re: how do i perform subtraction

swuehl — Sat, 27 Feb 2016 17:47:51 GMT

A little more details in your description would be helpful, it's pretty much unclear what you are trying to do here.

Maybe add something like this to calculate the difference between Inventory and Macs lines:

Concatenate (Final)

Load Dual ('Total1:',4) as Text,

Year,

Sum(If(No=26,Data))-Sum(If(No=36,Data)) as Data,

7 as SORT

RESIDENT Final

where WildMatch(No, '*26*', '*36*') and Match(SORT,1,3,5)

Group By Year;