Conditional Show

[Anonymous]

Hi

I need to do a conditional show for an object.

The object shows up when the two conditions are met:

1. If there's only one item selected.  Count (Distinct [ID]) = 1, and

1. when the value of a field [IsDiscounted?] = 'Yes'

I have difficulty combining these two conditions. Any idea?

Thanks

Yvonne

[Anil_Babu_Samineni · Accepted solution]

May be this?

If(GetSelectedCount(item) = 1 and Count(DISTINCT ID) =1 and Match(IsDicounted, 'Yes'), 1,0)

[petter]

In the Layout / Show Conditional you can have the following expression:

=GetSelectedCount([ID])=1 AND Count(DISTINCT [ID])=1 AND [IsDiscounted?]='Yes'

[sunny_talwar]

Is it possible to have multiple IsDiscounted values when a particular ID is selected? And if it does, do you want to see this when all those values are 'Yes' or if any of those values are 'Yes'?

[Anonymous]

It's one isDiscounted value per ID

[sunny_talwar]

Then I would think any of the above two suggestions should work for you

[Anonymous]

Thanks for your answer:)

Do I need both GetSelectedCount([ID])=1 and Count(DISTINCT [ID])=1?

Are they the same?

[sunny_talwar]

They are almost the same...

GetSelectedCount(ID) = 1 will only show 1 when you have selected directly 1 ID from the ID field

Count(DISTINCT ID) = 1 will show 1 when you have other selection drill down ID to have only one possible value of ID. For instance you selected a region, which happen to have only 1 ID, this will show 1.

So, depending on your requirement, you can choose one of the two