calculation in script

[capriconuser]

i have premium column now i want to do some calculation in sript

i do this 

load 
id
(Premium * 1.5 + 500,000) as Premium_cal
from

....

but this shows red line error in script

[sergio0592]

Try to use Resident. If Table 1 results of SQL query

Table2:
load
id,
(Premium * 1.5) + 500) as Premium_cal
resident Table1;

[NitinK7]

may be instead of this 

1.5 + 500,000

try like

1.5 + 500000

[MayilVahanan]

Hi @capriconuser 

Due to Comma in the script  , Qlik recognized that, line is ended so after that comma its considered the next field or some garbage values & throw error .

so, remove the comma and try again

((Premium * 1.5) + 500000)