topic Re: Straight table question in App Development

Straight table question

Annapurna1 — Thu, 02 Dec 2021 05:33:49 GMT

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.

Re: Straight table question

Vegar — Thu, 02 Dec 2021 05:42:08 GMT

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() ))

Re: Straight table question

Annapurna1 — Thu, 02 Dec 2021 08:42:07 GMT

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

Re: Straight table question

Annapurna1 — Thu, 02 Dec 2021 08:44:29 GMT

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..