get amount of hit

[keepcalm]

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.

[Qiu]

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

[keepcalm]

@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

[JarekSkudrzyk]

@keepcalm 

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

Hope I got your idea right.