Field value in Text object

[Anonymous]

Hi Experts,

Can we have a fields value on the basis of if condition in Text Object's text

Thanks in advance

[tamilarasu]

Like this.?

=If(GetSelectedCount(Field_Name)>0,Concat(Distinct Field_Name,', '))

[Kushal_Chawda]

Yeah, you can have, but can you explain what is your need?

[sunny_talwar]

Not sure I understand your question. Field value? May be like this:

=If(Condition, Concat(DISTINCT XYZ), 'Condition Not Met')

[Anonymous]

my script is like:

tblTest:

Load X,Y,Z;

Select * from testTable;

and what I want is in Text Object's Text

    =If(X=Y,Z)

Text object should display Z's value

[sunny_talwar]

This is for a particular selection you mean?

[Anonymous]

Actually I have only 1 match (X=Y) in entire table

So no need for selection

[ThornOfCrowns]

That's exactly the syntax you'd use.

[sunny_talwar]

Would you be able to share a sample with the expected output to help you better?

[Anonymous]

Hi Sunny and James,

Have droped the idea of using it on chart

But anyway Thanks a lot for replying