cancel
Showing results for 
Search instead for 
Did you mean: 

Want to use condition with formula keyfigure

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi ,

Can you please tell me what is the actual output you are expecting from the Sample data of your info set.

I am little confused...so asking again.

Result = 1.5 comes onnly when you set calculate result to avarage of all values...

Regards

Laxman

Former Member
0 Kudos

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

and I create condition for hide PO=1 because QTY(PO) =0 and set condition -> QTY(PO) not equal to 0 -> and execute report

but report still show PO1 because my formula of QTY(PO) = QTY(PO) / Number of record

-> (6+6-7+1)/4 = 1.5 at result row

I try make result equal 0 but I can't do

Former Member
0 Kudos

Then follow below steps.

1.create a new formula F1

F1 = SUMGT(Qty PO).

2.Create a condition on F1 GEgreater than or equal to) = 1

3.Hide this F1,as it is for technicla purpose we are doing.

Hope it helps..

Regards

Laxman

Answers (0)