Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. MaryMaryMorrison

    Export List of Bex Attributes from Query Designer

    Or is there an SAP tcode that I can use to do this?
  2. MaryMaryMorrison

    Export List of Bex Attributes from Query Designer

    I'm trying to get the key figures and attributes from Bex's in Query Designer so I can create a list of Bex's and attributes in excel. It lets me copy an attribute but only one at a time. Is there a way to extract the bex details to excel? Thanks, Mary
  3. MaryMaryMorrison

    Difference with negative and positive numbers

    So guess what I've convinced my client to look at the variances the NORMAL Way! Thank Goodness. But thanks for all your effort! Mary :)
  4. MaryMaryMorrison

    Difference with negative and positive numbers

    This is the formula that worked from Randy =IF(AND(K15<0,L15>0),ABS(K15-L15)*-1,ABS(K15-L15)) The only piece I'm missing is if K15 is less than L15, I need it to return a negative number 57-63= -6
  5. MaryMaryMorrison

    Difference with negative and positive numbers

    LOL! Yes this is for a particular client and he looks at things the wrong way. I am just trying to pacify him. I felt odd posting my question b/c technically it doesn't make sense to look at the difference that way. Anyways I do appreciate the help! Mary
  6. MaryMaryMorrison

    Difference with negative and positive numbers

    got it! Thanks so much for your help! :)
  7. MaryMaryMorrison

    Difference with negative and positive numbers

    Randy actually i meant if l15 < k15 then l15-k15
  8. MaryMaryMorrison

    Difference with negative and positive numbers

    Randy, Your formula worked! Except now I need to add if l15 is less than k15 then k15-l15? Mary :)
  9. MaryMaryMorrison

    Difference with negative and positive numbers

    No it doesn't work, I'm trying to say if K15 <0 and L15<0 then abs(k15)+(l15) and if k15<0 and L15 >0 then k15+(l15*-1) and if k15>0 and L15 >0 then k15+l15 and if K15>0 and l15<0 then k15+abs(l15). so there are 4 scenarios: 1. if k is negative and l is negative then return the diff as a...
  10. MaryMaryMorrison

    Difference with negative and positive numbers

    yes ? im confused, sorry
  11. MaryMaryMorrison

    Difference with negative and positive numbers

    Hi Andy, this mth profit last month profit diff in profit $(52,018.26) $(31,101.00) $(20,917.26) - last month we were expecting a loss of only -31101.00 but this month we anticipated -52018.26 in loss so that means the difference is 20917.26 additional in loss...
  12. MaryMaryMorrison

    Difference with negative and positive numbers

    Thanks Skip, I'm not sure how to add the abs to this formula, this is the formula I used for the first equation and it returns the positive 20K, unfortunately when I use it on the second equation it returns a positive value also instead of the negative 75k...
  13. MaryMaryMorrison

    Difference with negative and positive numbers

    I need to get the difference between last months estimated profit and this months estimated profit. The problem is if I have -31 for last month and -51 for this month I need the difference to be a positive number 20 not -20. The other problem is if I have 56 for last month and -20 for this...

Part and Inventory Search

Back
Top