Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm loading a table from an excel file, I'd like to create a column with calculate values like this:
Load
[value A],
[value B],
[value C],
[value A] + [value B] + [value C] as vSUM // the new calculated column
FROM
[data.xls]
(biff, embedded labels, table is [Elenco dati contabili$]);
How can I do that?
Thank you.
Lorenzo
Load
[value A],
[value B],
[value C],
Rangesum([value A] , [value B] , [value C]) as vSUM // the new calculated column
FROM
[data.xls]
(biff, embedded labels, table is [Elenco dati contabili$]);
The way you have it should work, if there are nulls in your data you may need to do...
alt([value a], 0) + alt([value b], 0) + alt([value c], 0) as vSUM
Use rangesum() instead of multiple alt() - it automatically turns null() into 0.
Hi Lorenzo,
remember that with front end objects you can always do the sum so I wonder if thet total is really useful ... if it is use rangesum ...
Hi, which is the syntax of rangesum()? How can I use it?
Thanx
Load
[value A],
[value B],
[value C],
Rangesum([value A] , [value B] , [value C]) as vSUM // the new calculated column
FROM
[data.xls]
(biff, embedded labels, table is [Elenco dati contabili$]);