The QUERY function is part of the google visualisation api. The concanate is only to fit it a in-sheet dynamic link.
Am Sonntag, 20. April 2014 22:37:01 UTC+2 schrieb Domenik Reitzner: > > > <https://lh6.googleusercontent.com/-cFYJn68cR6Q/U1QuBWGs0NI/AAAAAAAADso/dzoEDGlHIJw/s1600/screen01.png> > > Here the SUM does not work in the "HABEN" column. > > But in the "SOLL" column it works. > > It looks like the numbers are formatet as plain text and can not be > formatet into currency. > > > <https://lh3.googleusercontent.com/-fN5jSTcjY9o/U1Qu0CgyQ7I/AAAAAAAADsw/Pvxp4bwO2eA/s1600/screen02.png> > > This is the Tab where i load my stuff from and the SUM does still work > perfectly. > > The Query funktion i use: > > =QUERY('S/H zwischen'!B:H; CONCATENATE("select C,D,E,F,G,H where B like > '%";Q1;"%'";" order by C");0) > > > I hope anyone can help... I have worked some hours on that problem and it > still remains. > > here is the link to a copy of the spreadsheet: > https://docs.google.com/spreadsheets/d/1IEgt29l1-VYrkU6bN7Y2c6E8U8tMpd8jXUQmF2-Z3d4/edit?usp=sharing > > > thx in advance > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout.
