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    Feb 11, 2013
user Craig Willox said:(!category-topic/docs/spreadsheets/OWi61aC-p8Y)
Spreadsheet Query - ABS() Support

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,

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