Sunday, February 10, 2013

yogi_WorkAround For ABS Value Of a Field In Select Clause Using QUERY Function


                                          Google Spreadsheet   Post  #1023
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Feb 11, 2013
user Craig Willox said:(http://productforums.google.com/forum/?zx=6cfvmrvdaezo#!category-topic/docs/spreadsheets/OWi61aC-p8Y)
Spreadsheet Query - ABS() Support
Hi,

For the QUERY command in a spreadsheet, would it be possible to support the ABS() sql function to retrieve the absolute value?
eg... =QUERY(RawData!A1:O500,"select A,B,F, ABS(F) absValue")

Or is there another way to do this?

Thanks in advance,
Craig
--------------------------------------------------------------------------------------------------------------

following is a WorkAround For ABS value of a field in the SELECT clause using QUERY function