Platform

Β View Only

 Use Various in Criteria of Formula

Jump to  Best Answer
  • TBMStudio
Kristine Klein's profile image
Kristine Klein posted Wed August 07, 2024 02:12 PM

Can you identify the rows in a table that returned various after grouping? I tried this formula but it doesn't recognize {Various} in the formula. Is there another way to find those rows?

=if(Primary Supplier Name= {Various},"",Primary Supplier Name)

#various

#formulas

#TBM Studio


#TBMStudio
Jenny Franklin's profile image
Jenny Franklin posted Thu August 08, 2024 06:29 PM  Best Answer

Hi Kristine, have you tried putting quotes around "{Various}"?  


#TBMStudio
Michael Enslein's profile image
Michael Enslein posted Thu August 08, 2024 11:26 AM

I think the issue you having is the Various, you use the =if(Primary Supplier Name in ( {Various}, "Various").  It is sometimes different on how this is returned.  Do you have the Primary Supplier Name as a grouping?  You could also a normalization before the grouping.  Feel free to reach out.   


#TBMStudio
Kristine Klein's profile image
Kristine Klein posted Thu August 08, 2024 12:26 PM

It's unusual I know, but in this particular case I don't want to group it. It's not necessary data and only needed if there is one result. I am using it in when I group assets into capital approval numbers for mapping purposes. I want to change any results that return as various (the dots) to BLANK.  


#TBMStudio
Kristine Klein's profile image
Kristine Klein posted Tue August 13, 2024 11:14 AM

Thank you Jenny. That worked!!!


#TBMStudio
Jenny Franklin's profile image
Jenny Franklin posted Tue August 13, 2024 01:34 PM

Most welcome - glad to hear it worked! 😊


#TBMStudio

Related Content