Sum in the script

[smilingjohn]

Hi Expetise

How to perfrom sum in script . I am trying to write
sum(A) - sum(B) as Result
i have taken the resident of the table and used group by also but while reloading it shows the error .
how to handel this ?

Thanks in advance

[StarinieriG]

Hi,

maybe you are missing a field inside group by.

Could you share your script?

[smilingjohn]

This is not working 

Test:
LOAD Month,
O,
C
FROM
[C:Sample-Runing.xlsx]
(ooxml, embedded labels, table is Sheet1);

Load
Month,
Sum(C)-sum(O) as Running
Resident Test
Group by Month;

When loaded this is giving the error 

[Brett_Bleess]

John, what is the error you are receiving?  Screenshot would likely be best, this should give us something better to go on here, as at the moment I have no idea.

Regards,
Brett