Hello, it looks like this is a docs question, and not a charts question, so I would direct you to https://productforums.google.com/forum/#!forum/docsto ask your question. I am no expect in these matters, but what it looks like is that you're using CONCATENATE, which I'd expect to return a string, not a number.
- Sergey On Sun, Apr 20, 2014 at 4:37 PM, Domenik Reitzner <[email protected] > wrote: > <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. > -- 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.
