Skip to Content
avatar image
Former Member

How to Disply all customers and all amounts .

I have customer numbers and respective amounts in my query

I want to do one customer amount divide by 100 and I want to display all customer numbers and amounts including the customer number devide by 100 also how?

Can any body let me know please.

Regards,

VR

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Sep 20, 2010 at 11:41 AM

    Hi,

    Create a new formula with Boolean operators such that, your formula (divided by 100) must satisfy only to that customer number and remaining values must be same as KF's output.

    http://help.sap.com/saphelp_nw04/helpdata/en/23/17f13a2f160f28e10000000a114084/frameset.htm

    Hope this helps....

    Rgs,

    Ravikanth.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Venkat,

      No need to use RKF, I am suggesting you to use a formula and put a if else condition using Bolean operators such that the formula will be applicable to only those customers which should be divided by 100 else display the same value.

      For ex:- In the formula(can be done using Bolean operators) , logic will be applicable such as:

      IF Sales > 10000, then sales = sales/1000

      else sales = sales.

      here Sales > 10000 or similar condition should identify the customers for the formula to be applied.

      Hope this helps......

      Rgs,

      Ravikanth.