Search results for query: *

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

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

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 :)

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

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

got it! Thanks so much for your help! :)

Randy actually i meant if l15 < k15 then l15-k15

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

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...

yes ? im confused, sorry

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...

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...

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...