Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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'))))
Use GetPossibleCount function instead of GetSelectedCount.
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')))
Hi Friends,
Appreciate your time. Unfortunately both didn't worked. attached the screenshot of what I got when I changed the expression.
thanks,
Kiruthiga
screenshot?
attached,Thank you!
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
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')))
Hi Sunny,
It's not working for the other scenario.
Attached for your reference.
Thanks!
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'))))