Simple division in script

[Anonymous]

I have a really simple plan - But can't execute.

I want to divide something i am bringing in by 100.

So e.g.

Load 8*;

SQL Select

Amount /100

from x.table

And cant seem to do it.
Any ideas.

[rubenmarin]

Hi Jamal, maybe with:

Load Amount/100 as Amount;

SQL Select Amount

from x.table