calculation!!

[#1]

Hi All,

             I need to  calculate   CAL column some values based on cat:

Res Id	101	102	103	104	105	cat	cal
1001	8	1	4	5	6	SV
1000	4	2	5	7	9	Tw

=(8*weight )+(102*weight)+(103*weight)+(104*weight)+(105*weight)multiply by 10 how i can write a expression here

[#2]

Sry gus i did a mistake

=(value of 101*weight )+(value of 102*weight)+(value of 103*weight)+(value of 104*weight)+(value of 105*weight)multiply by 10 how i can write a expression here

[its_anandrjs]

Elaborate more please..

[its_anandrjs]

101,102....105 are columns or field values.

[MK_QSL]

8*weight or 8* 101?

[Anonymous]

Hi Suneel,

PFA for your expression.

Cheers!

Laxmi

[#7]

Thank u so much but

Here Cat1 has some weight value and Cat2 has some weight value  how we can do

What is the if condtion

[Anonymous]

What is CAT1 and CAT2 in this example?

[#9]

Category 1  and Category 2

here Category 1 = Sv and Category 2 =TW

Sv has own weight value and Tw has Own own weight value

in  your example only one weight value is there right

[Anonymous]

You can create another expression called "Weight" and change its values based on your condition.

I have attatched the updated .qvw file.

Hope it helps you.

Cheers!

Laxmi