Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
Here is my requirement..
If i have 3 Columns then if Col(1)>0 ,Col(2)=0 and Col(3)>0 then my Last column should be TW/HL
in the same way
If i have 3 Columns then if Col(1)=0 ,Col(2)>0 and Col(3)=0 then my Last column should be FM
Its an urgent requirement can you please help me out with this asap.
Try an IF(IF)) statement.
IF(Column(1)>0 and Column(2)=0 and Column(3)>0, 'TW/HL', IF( Column(1)=0 and Column(2)>0 and Column(3)=0, 'FM', NULL() ))
TW | Farm | Farm Digital | HL | CL | ||||||
Count | Value in CR | Count | Value in CR | Count | Value in CR | Count | Value in CR | Count | Value in CR | Product |
FM | ||||||||||
TW/FM | ||||||||||
TW/FM/HL | ||||||||||
TW/HL |
No, the requirement is...if Count of TW is >0 the product column should be TW, if count of TW and FM > 0 then product column should be TW/FM, in the same way if Count of all TW FM HL and CL > 0, then product column should be TW/FM/HL/CL
Please help me out as its urgent requirement..