Skip to Content
0
A J
Mar 23, 2012 at 03:46 AM

Want to use condition with formula keyfigure

25 Views

My report is claim report.

I display quantity of waste products that return to vender and good products that receive from vendor. But this report use data from infoset that join between PO ODS and GL Line item ODS

example of infoset data:

PO POitem QTY(PO) GL Doc GL Doc item Amount

1 1 6 1001 1 5,000-

1 1 6 1001 2 15,000

1 1 -7 1002 1 15,000-

1 1 1 1003 1 5,000

report display:

PO POitem QTY(PO) GL DOC Amount

1 1 6 1001 10,000

1 1 -7 1002 15,000-

1 1 1 1003 5,000

result 0 0 -> use property calculate result as summation. if no setting, result is (6+6-7+1)/4 = 1.5

My setting:

QTY(PO) use formula keyfigure = QTY(PO) / Number of record

and I create condition with QTY(PO) not equal to 0

I want hide item that result is equal 0. But my report display it because real result is (6+6-7+1)/4 = 1.5

I want it use result as summation for condition.

please help me.