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
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
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.