Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Does anybody know of a way of summing data and keeping the original fieldnames without having to use AS ? For example, if I have fields, 'Cost Price', 'Sale Price' and 'Tax', I am currenly saying
LOAD Sum ([Cost Price]) As "Cost Price",
Sum ([Sale Price]) As 'Sale Price',
Sum (Tax) As 'Tax'
It would be nice just to be able to issue the SUM without having to rename the fields back to what they originally were.
Hi, David.
I don't think it is possible.
The result would be the same in SQL or Oracle.
Maybe you could just load the data (without grouping it) and them use sum, avg, etc inside the interface.
This way the users would be able to explore the details.
Regards,
Erich