Skip to Content

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

Remove zero value from Query analyzer out put.

Dear experts,

I have vendor ageing query in this i have 6 keyfigures

Total,   overdue,   1-30,    31-60,     61-90,       >90

0            0              0          -100       100             0

25           5             0              0          5              0

if you see my first record the total and overdue is zero. records with Total keyfigure  zero should be eliminated.

Kindly guide me on this.

Regards,

Naveen

Tags:
Former Member replied

hi Naveen,

put 1-30,    31-60,     61-90,       >90 in a Calculated keyfigure:

add the condition:

((Total AND Overdue > 0 ) * 1-30 )

then if you supress 0 values, it won't be displayed.

rgrds,

Mathijs

0 View this answer in context

Helpful Answer

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