The query is being used in a third sheet
On Friday, October 27, 2017 at 12:25:43 PM UTC+5:30, prashanti wrote:
>
> Can someone please hint me what is the problem with this query?
>
> = Query({Query({Sheet1!$A2:$G,Sheet2!$A2:$H},
> "select Col1,Col2,Col3, MULTIPLY(Col7, Col15) where Col1=Col8 and
> Col3=Col9 group by Col1, Col2, Col3 label MULTIPLY(Col7, Col15) ''")},
> "select SUM(Col4) where Col1=" &A2& " and toDate(Col2)= date '"&text(B2,
> "yyyy-MM-dd")&"' label SUM(Col4) ''")
>
--
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 https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit
https://groups.google.com/d/msgid/google-visualization-api/8cac4b41-8c9d-45d0-b9f2-bc1dde2d7db0%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
