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.