Skip to Content

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

Formula/condition advice...

Greetings SDN community. i have a report specification which is similar to this;

-


________water______

________sewer_________

amt

vol

count

amt

vol

count

-


customer a 999.00 9 1

customer b 99.00 2 1

in determining whether an account should fall under water or sewer, i use a keyfield, 'rate'. if rate = 01, it will fall under 'water. if rate = '02', it will fall under 'sewer'.

where should i build this condition or formula so that each customer should fall under their respective categories.

regards,

jay

Former Member
Former Member replied

You have to restrict the Key Figure with Rate right click on the Key Figure.and click on Restrict.Then Restrict Rate with 1. Drag and drop another Key Figure and restrict this on Rate with 0. Keep 2 names for the same key figure.

Let me know if not clear

0 View this answer in context

Helpful Answer

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