Hi Vinu, We did see your first message on this topic, and also replied to it. But I think you're still not subscribed to the mailing list to get the responses ... Send a mail to [email protected] to get subscribed.
Best regards, Kasper 2014-08-11 5:32 GMT+02:00 Vinu Agnihotri <[email protected]>: > Hi Kasper, > > I am from Singapore and have recently started using the META Model. > > My Database is a CSV file. > > I am using the aggregate SUM function in a simple Aggregate Function using > a group by query. > > Select...... (FUNCTION.SUM, (Column_Name) > > In this case there is a time where the values in the row is blank or null > for the column for which I am doing the SUM Aggregation > > When this is the case I am getting an error "Could not convert to number: " > " > > What I intend to do is either make the value 0 when it is Null or not > include these null values while doing the aggregation. > > NO Name Amount > 1 Origin 50 > 2 House > 3 Origin 30 > 4 House 40 > > In the above example when I do a SUM on Amount group by Name, I expect to > have two rows as a output with origin as 80 and House as 40 as their > Amounts , but since for no 2 the amount is null, My code does not complies > and I get the error. > > > My apologies for asking such an easy question > > Thanks > Vinayak >
