Calculate Percentage in load script

[dseelam]

Hello All,

How to Calculate Percentage in load script, We give allowance to customers on top of gross sales, I have $ amounts given on CSV for allowance how to calculate allowance% from it, in load script itself?

Attached Sample

Thanks,

D

[ahaahaaha · Accepted solution]

Hi,

If I understood you correctly, maybe like this?

LOAD

    ITEM_NUMBER,

    GROSS_SALES,

    fabs( ALLOWANCES) as ALLOWANCES,

(ALLOWANCES/GROSS_SALES)*100 as Percentage

FROM

(txt, utf8, embedded labels, delimiter is ',', msq);

[sunny_talwar]

May be this?

fabs(ALLOWANCES)/GROSS_SALES as [ALLOWANCE %]