Regarding displaying format

[skiruthigadevi]

Hi Friends,

I appreciate your time. I am looking for your help in my scenario. I have Vendor Number, Vendor Name and Vendor_Final in my table.

when I select single vendor number my list box should show the vendor details and in case if I select more than one vendor it should display "Multiple Vendor selected" message.

my calculation is showing "multiple vendor selected" message when I select multiple vendor number but  when I select multiple vendor names it is not showing the "multiple vendor selected" message. I have attached a sample application for your reference.

Thanks,

Kiruthiga

[neelamsaroha157]

Use GetPossibleCount function instead of GetSelectedCount.

[sunny_talwar]

Might make sense to leave the first GetSelectedCount() as is

='VENDOR :'&if(GetSelectedCount([Vendor_Number]) = 0,

[Vendor_Number]&CHR(32)&'-'&CHR(32)&Vendor_Name_Final,

if(GetPossibleCount([Vendor_Number])=1,

[Vendor_Number]&CHR(32)&'-'&CHR(32)&[Vendor_Name],

if(GetPossibleCount([Vendor_Number])>1,'Multiple Vendors Selected')))

[skiruthigadevi]

Hi Friends,

Appreciate your time. Unfortunately both didn't worked.  attached the screenshot of what I got when I changed the expression.

thanks,

Kiruthiga

[sunny_talwar]

screenshot?

[skiruthigadevi]

attached,Thank you!

[skiruthigadevi]

Hi Neelam,

Thank you and appreciate your time. The expression looks like attached image when nothing is selected but it should display vendor name final instead.

Thank you!

Kiruthiga

[sunny_talwar]

This is what neelamsaroha1575‌ suggested... try this

='VENDOR :'&if(GetPossibleCount([Vendor_Number]) =0,

[Vendor_Number]&CHR(32)&'-'&CHR(32)&Vendor_Name_Final,

if(GetPossibleCount([Vendor_Number])=1,

[Vendor_Number]&CHR(32)&'-'&CHR(32)&[Vendor_Name],

if(GetPossibleCount([Vendor_Number])>1,'Multiple Vendors Selected')))

[skiruthigadevi]

Hi Sunny,

It's not working for the other scenario.

Attached for your reference.

Thanks!

[neelamsaroha157 · Accepted solution]

Try this -

='VENDOR :'&

If(GetSelectedCount(Vendor_Number) + GetSelectedCount(Vendor_Name)=0, 'No Vendor Selected',

if(GetPossibleCount([Vendor_Number]) =0,

[Vendor_Number]&CHR(32)&'-'&CHR(32)&Vendor_Name_Final,

if(GetPossibleCount([Vendor_Number])=1,

[Vendor_Number]&CHR(32)&'-'&CHR(32)&[Vendor_Name],

if(GetPossibleCount([Vendor_Number])>1,'Multiple Vendors Selected'))))