[SIZE=12px]When in an event OnScriptInit use the macro sc_select_field (test) = test1 the new field isn’t add in the total even if it is already abilitated in GRID/Totals/Totals
Observing this dubug the FIELD CASE WHEN … : doesn’t comprend the sum(…)[/SIZE]
sum(m.Quantita), CASE WHEN m.CodMagazzinoArrivo=2134 AND m.CodMagazzinoPartenza=2134 THEN CONCAT(cm.SegnoMA,1)* m.Quantita WHEN m.CodMagazzinoPartenza=2134 THEN CONCAT(cm.SegnoMP,1) * m.Quantita WHEN m.CodMagazzinoArrivo=2134 THEN CONCAT(cm.SegnoMA,1) * m.Quantita END from Movim m LEFT JOIN Prodotti p ON p.Codice=m.CodProdotto LEFT JOIN Magaz m1 ON m1.Codice=m.CodMagazzinoPartenza LEFT JOIN Magaz m2 ON m2.Codice=m.CodMagazzinoArrivo LEFT JOIN Operat o ON o.Codice=m.CodOperatore LEFT JOIN Clienti c ON c.Codice=m.CodCliente LEFT JOIN SitCli sc ON sc.Codice=m.CodSito LEFT JOIN CauMov cm ON cm.Codice=m.CodCausale LEFT JOIN Zone z ON z.Codice=sc.CodZona where (m.CodProdotto = ‘3637’ ) AND (m.CodMagazzinoPartenza=2134 OR m.CodMagazzinoArrivo=2134 )