Sum of Multiple fields into one while loading

[#1]

Hi,

Below load script fails to sum up all the values

Load

residentialunitprice+maintenancefundprice+totalcustomizationcharges+totalservicetax+totalvat+wc as S_TotalCharges

FROM

[$(vPath)\tesaleorde.qvd]

(qvd);

But when i load all the above fields separately and sum up it shows correct value.

Please help me with this.

Regards,

Keerthi KS

[#2]

Currently i have used

if(IsNull(residentialunitprice),0,residentialunitprice)+if(IsNull(maintenancefundprice),0,maintenancefundprice)

    +if(IsNull(totalcustomizationcharges),0,totalcustomizationcharges)+if(IsNull(totalservicetax),0,totalservicetax)

    +if(IsNull(totalvat),0,totalvat)+if(IsNull(wc),0,wc) as S_TotalCharges

[jagan]

Hi Keerthi,

Did you tried my solution?  Rangesum() will do all this checks.

Regards,

Jagan.

[#4]

Hi Jagan,

Yes I have tried your approach and Its working.

I have used '+' instead of ',' so it was not working.

Thanks a lot.

Regards,

Keerthi

[jagan]

Hi Keerthi,

If you got the answer please close this thread by giving correct and helpful answers to the helpful posts.

Regards,

jagan.