Skip to Content
avatar image
Former Member

query formula problem BW 3.5

Hi,

we are working on BW 3.5 and we have a simple query with a wrong total, we have tried to show total as summation but it's not an acceptable solution because customer is not in default drill down

thanks

Customer        Quantity         Price        Sales
C1               3               5             15
C2               11              2             22
Total            14              7             98 (should be 15 + 22)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Dec 01, 2017 at 11:14 AM

    hello,

    can you check and tell me what Property is there under the Formula Collision for the both Formula.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 04, 2017 at 08:50 AM

    Hi

    I guess Sales= Quantity mulplied by Price, so what you get in you resultline is what you have defined. You'll need to set the calculation of your total line as SUM, go to properties of your formula -> calculation -> show result line as total

    grtz

    Koen

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 04, 2017 at 10:34 AM

    Hello Koen,

    thanks, but it's not a solution as i sayed the customer is not always in the drill down, displaying result as summation is only a display option

    any other ideas ?

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      I did in BW 7.X, to be honest, I overlooked your BW 3.5 mention. My apologies

      I have no BW 3.5 installation at my disposal, so I'm afraid I can't check in system.

      Best advise is to work it out in BW. It should work fine that way.

  • avatar image
    Former Member
    Dec 01, 2017 at 11:42 AM

    Hello,

    how to get this property in BW 3.5 ?

    Thanks

    Add comment
    10|10000 characters needed characters exceeded