Value in Text Box

[mohammadkhatimi]

  HI,

OID	Value1	Value2	Value3
1	100	0	100
2	0	150	150
3	200	0	200
4	0	250	250
5	300	100	300

We need Value3 in text box..

Logic is if Value1 is zero than pick Value2 else Value1..This is done in staright table but requirement is in textbox...

How to show plz help...!!!

Regards,

Mohammad

[swuehl]

Which value of column "Value3" do you want to show? An aggregated, summed value?

=Sum( If( Value1, Value1, Value2))

or maybe a concatenated string?

=Concat( If( Value1, Value1, Value2), ', ', OID)

[mohammadkhatimi]

I tried below logic but its not working.

Its showing only Value1 values not Value2

=Sum( If( Value1, Value1, Value2))

[mohammadkhatimi]

In above example which I shared its working but if I'm applying on my data than its not working..

Results comes only Value1

[trdandamudi]

Can you please share a small sample to test it out...