Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

how to set evaluation in manual running total

Morning all,

I am trying to create a manual running total however I need to setup an evaluation by using a filter field.

For example

Running Total:

Summary: foc.doc_no

Summary Type: Distinct Count

Evaluation: Formula - foc.linetype="F"

Reset: Group2(foc.reasoncode)

Now the question is how to use the above in the formula.

Whileprintingrecords;
numbervar x:=0;
numbervar y:=0;
numbervar z:=0;
x:=DistinctCount(foc.doc_no),foc.reasoncode;
y:=(foc.linetype="f")

If y=true then 1;
z:=x+sum(y)
z;

I know the above code could be wrong (most probably is) however it gives you an idea what I am trying to achieve.

If I use temp SQL Command. the report takes forever to calculate so I don't think I would be using that.

Any ideas how to do this sort of running total (manual).

Many thanks

Regards

Jehanzeb

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question