Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Elaborate more please..
101,102....105 are columns or field values.
8*weight or 8* 101?
Hi Suneel,
PFA for your expression.
Cheers!
Laxmi
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
What is CAT1 and CAT2 in this example?
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
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