Summation of all except 7 criteria, give result amount 0

[pegaga1979]

hi,

i try to do summation based on all fields except the 7 fields that i already put in specific column. which i declared as others.amt.
but it print qty 0.

is there anything that i do wrong?

declaration:

	domain	tcamnt	others.amt, others.amt1


detail.1:
before.layout:
	if whina124.fitr<>tcfitr.adjustment and whina124.fitr<>tcfitr.revaluation and whina124.fitr<>tcfitr.value.correct and whina124.fitr<>tcfitr.issue and whina124.fitr<>tcfitr.var.adjustment and whina124.fitr<>tcfitr.receipt and whina124.fitr<>tcfitr.ftp.result then
		others.amt = others.amt + whina124.amtf(1)
	endif

lattr.print=false	

after.whina124.itmt.1:
after.layout:
	others.amt = 0

your support is highly appreciated.tq

[pegaga1979]

tried below code also can't:

declaration:

extern	domain	tcamnt	others, total, rec, issue, adj, val.corr, var.adj, rev, result

detail.1:
before.layout:

	total = total + whina124.amtf(1)

	if whina124.fitr = tcfitr.receipt then
	rec = rec + whina124.amtf(1)

	else if whina124.fitr = tcfitr.issue then
	issue = issue + whina124.amtf(1)
	
	else if whina124.fitr = tcfitr.adjustment then
	adj = adj + whina124.amtf(1)

	else if whina124.fitr = tcfitr.value.correct then
	val.corr = val.corr + whina124.amtf(1)

	else if whina124.fitr = tcfitr.var.adjustment then
	var.adj = var.adj + whina124.amtf(1)

	else if whina124.fitr = tcfitr.revaluation then
	rev = rev + whina124.amtf(1)

	else if whina124.fitr = tcfitr.ftp.result then
	result = result + whina124.amtf(1)
	
	endif
	endif
	endif
	endif
	endif
	endif
	endif


lattr.print=0	

after.whina124.itmt.1:
before.layout:
	others = total - rec - issue - adj - val.corr - var.adj - rev - result

after.layout:
	total = 0 
	rec = 0
	issue = 0
	adj = 0
	val.corr = 0
	var.adj = 0
	rev = 0 
	result = 0

[mark_h]

When you debug the report does it hit the detail.1 before layout? Do you have a physical layout in the report called layout.1?

[pegaga1979]

Hi Mark,

when i enable detail.1 to print out, amount for field "others.amt" or "others" still not come out. seem it disable to calculate.

[mark_h]

Put it in debug mode and see if it hits the code in the detail.1, before:layout. You need to make sure the code is getting hit first.

[pegaga1979]

Originally Posted by mark_h

Put it in debug mode and see if it hits the code in the detail.1, before:layout. You need to make sure the code is getting hit first.

it seems, it is not calculate and read the formula.
where is the wrong?

[mark_h]

Are whina124.amtf(1) and whina124.fitr input fields on the report? When in debug mode you should be able to click on them and see the value. You should be able to watch it hit one of the calculations.

[pegaga1979]

Hi Mark,

thank you much. just noticed as my input is whina124.itmt i should use whina124.amtt(1) and not whina124.amtf(1).

it is working perfectly now

thank you so much.