Subtracting numbers from two different records

Markfre1

I have a complicated spreadsheet that I now have in AIm's Db. Through AIM Ii create all types of subtotals, averages per record (no problem). Now I need to do a simple task of taking 1 number from a 2013 record and subtracting 1 number from a 2014 record. Getting stuck. I was using a process to' find' the 2013 record and get the first number. Then I was using a 'Find' to get the 2014 number. Becasue I used another find, the first was out of context so I can't subtract one from the other.

FIND GrandTotals WHERE (GrandTotals.Year=MonthlyTransactions.Year-1 AND GrandTotals.Hospital=MonthlyTransactions.Hospital)
(So this gets the total for the previous year.)

GrandTotals.Difference=GrandTotals.GrandTotalPharmacyPoCOSTAdjustedDayAverage
(I need to store this number to use, but don't even really want it in this difference)

(Now I am finding Current year)
FIND GrandTotals WHERE (GrandTotals.Year=MonthlyTransactions.Year AND GrandTotals.Hospital=MonthlyTransactions.Hospital)

So this gets the total for the current year. But now I have to subtract the one from the other.
(This amount is what I want in this year, and nothing in the other first find (last Year). Last Year will get updated in the same manner though.

So basically its where last year subtracts this year, and keeps going for all years.

I don't think you can combine the "find" where I find the first, number and second number, and then subtract the two?

It's probably basic, but I am stuck.

Any help in pointing me in the right direction will help.

Thanks,

Mark

Markfre1

Just saw something regarding 'This,That'? Looking into it?

Markfre1

FIND GrandTotals WHERE GrandTotals.Year=MonthlyTransactions.Year and GrandTotals.Hospital=MonthlyTransactions.Hospital
FIND GrandTotals WHERE GrandTotals.Year=MonthlyTransactions.Year-1 AND GrandTotals.Hospital=MonthlyTransactions.Hospital
ThisGrandTotals.Difference=ThatGrandTotals.GrandTotalPharmacyPoCOSTAdjustedDayAverage-ThisGrandTotals.GrandTotalPharmacyPoCOSTAdjustedDayAverage

Just was wondering if I needed to subtract 3 or 4 or more records. Maybe the this and that can keep being repeated?

rbross

Mark
This and that I would think would work for this.
I would try splitting your finds up into separate processes.
So call a process to do your fist find. From that process call another process to do you second find. Passing the BO from your first find. Then try your subtraction
This way the BO you are passing will still be in context. You may or may it need to use This and that when you do it this way.

Keep in mind awareIM is process each record one at a time kind of like Magic does with Record Suffix.
So if you pass the BO as a parameter you know it will alway be just one instance/ record for the first find that you do.

HTH
roger

Markfre1

Roger, Thank you. The This/That worked well but you now gave me an alternative to think about. Regards, Mark

rbross

That's good Mark,

Since I have been working with AwareIM I have been heavily into processes.
When ever you pass a BO it will remain in context and you don't have to use This with it.
At least that has been my experience so far...

Roger

Markfre1

I need to read up a little more, because it seems when I did a find to get the next one, I lost the one in context that was passed, so I needed to find both again. I did so much testing, I might be wrong, but it works now. But I may revisit the whole enchilada. Because when a record is changed, I am going through 1/2 dozen process to recalculate a lot of totals as everything is based on everything else. It almost seems like I have to do this.

My other thought was to have a button to start all these processes when the input is complete instead of after every transactions. But this is working for the moment, and then I will revisit this as a batch process later.

Now I have a situation where I have to roll totals forward from 1 year to another in which each record is seperate, and this is another confusing issue. That's for another day.

Thanks for your input.

Mark

rbross

Mark
If understand what you need to I might have a solution for you but I would have to show you. I'll be in touch.

Roger