get amount of hit

Question

hi team,

I have a workflow where i need to get "Amount of hit."

i.e "No of counts" minus the figures in "Static Table" in descending order.

Eg 67 minus  66  which is 1 then minus off last figures which is 1(since balance 1 cant be minus off with others since itll be negative) which is 2 hits.

Note: No of counts minus static table (descending order) should always be 0.

Any clue to this? Thanks.

JarekSkudrzyk · Answer

@keepcalm

Please try this solution - it is based on iterative macro.

Hope I got your idea right.

Amount of hits.yxzp

keepcalm · Answer

@Qiu

Eg Take 67 as count

i.e 67 - 66 = 1 (counted as 1 hit), 1(which is the balance) - 1 =0 (counted as 2 hit)

Final figures should always be 0 and figures to minus off cant be a negative

Eg 67 - 66 = 1 then taking 1 - 30= -29 which is why the static table is based on descending order which can be minus off

that will not equal to a -ve.

Hope this clarifies

Qiu · Answer

@keepcalm 
I am having difficulty in understanding the logic here.
Can you try to eloborate it?
Thanks.