Scripting

[#1]

Hi Team,

Can any one give the solution.

These are actual table fields.

A               B         C

Health        3         -

Health        -         15

but I require B/C in scripting.

Thanks

krish

[sunny_talwar]

May be this:

LOAD A,

          RangeMax(B) as B,

          RangeMax(C) as C,

          Sum(B)/Sum(C) as [B/C]

From ...

Group By A;

[florentina_doga]

try this

z:

load * inline [A, B, C

Health, 3,

Health,, 15];

zz:

load *,(b/c) as bc;

load A,

sum(alt(B,0)) as b,

sum(alt(C,0)) as c

resident z group by A;

drop table z;

[sunny_talwar]

My bad, may be this:

LOAD A,

          Sum(B) as B,

          Sum(C) as C,

          Sum(B)/Sum(C) as [B/C]

From ...

Group By A;

[Anil_Babu_Samineni]

A               B         C

Health        3         -

Health        -         15

From this What are you expecting

A               B         C          B/C

Health        3         -            3/-

Health        -         15          -/15    

[sunny_talwar]

I think something like this:

[#7]

Hi Sunny,

Thank you for given information.

Regards,

krish