How to calculate percentage

[#1]

I have 3 fields.

%Growth,%GrowthCY and TotalFTECY

TotalFTECY=3735

%GrowthCY=100%

%GrowthNY = 3%

now I need to calculate TotalFTENY

So basically it is (3735*3)/100

How can I do this in qlikview?

Thanks much.

[sunny_talwar]

Try this in that case:

(Num#(KeepChar([TotalFTECY], '0123456789'), '##') * Num#(KeepChar([%GrowthNY], '0123456789'), '##'))/100 AS [TotalFTENY]

[#3]

Hi,

Try as below and see the result,

LOAD TotalFECY,

     %GrowthNY,

     %GrowthCY,

     ([TotalFECY]*[%GrowthNY])/[%GrowthCY] as TotalFTENY

FROM

(biff, embedded labels, table is Sheet1$);

Result:

Thanks,

Mahesh