Where would I place 'ABS', in the second formula after the /, to make it work correctly?

rhservan
rhservan used Ask the Experts™
on
= (Fields!W1.Value -

((Fields!W2.Value + Fields!W3.Value + Fields!W4.Value + Fields!W5.Value + Fields!W6.Value + Fields!W7.Value + Fields!W8.Value + Fields!W9.Value + Fields!W10.Value + Fields!W11.Value + Fields!W12.Value + Fields!W13.Value)/12))

/

((Fields!W2.Value + Fields!W3.Value + Fields!W4.Value + Fields!W5.Value + Fields!W6.Value + Fields!W7.Value + Fields!W8.Value + Fields!W9.Value + Fields!W10.Value + Fields!W11.Value + Fields!W12.Value + Fields!W13.Value)/12)
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
ABS must be outside the () of the value you want to convert.

The only one who knows that answer is you. I think you mean the reslut of the second /12 must be the subject of the ABS()

= (Fields!W1.Value - 

((Fields!W2.Value + Fields!W3.Value + Fields!W4.Value + Fields!W5.Value + Fields!W6.Value + Fields!W7.Value + Fields!W8.Value + Fields!W9.Value + Fields!W10.Value + Fields!W11.Value + Fields!W12.Value + Fields!W13.Value)/12))
/ 
abs((Fields!W2.Value + Fields!W3.Value + Fields!W4.Value + Fields!W5.Value + Fields!W6.Value + Fields!W7.Value + Fields!W8.Value + Fields!W9.Value + Fields!W10.Value + Fields!W11.Value + Fields!W12.Value + Fields!W13.Value)/12)

Open in new window

Author

Commented:
To be precise below is the second formula.  
Where exactly will abs correctly be placed formula between (( )/12). This would be to obtaind the absolutes of all the .Values in the formula.

((Fields!W2.Value + Fields!W3.Value + Fields!W4.Value + Fields!W5.Value + Fields!W6.Value + Fields!W7.Value + Fields!W8.Value + Fields!W9.Value + Fields!W10.Value + Fields!W11.Value + Fields!W12.Value + Fields!W13.Value)/12)

Commented:
That looks exactly as I posted  except for the abs -> ABS

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial