Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

remove delimiter if combinevalues empty

I have a large COMBINEVALUES doing combination of Ifs...but when there results all return false, it returns "" for the ifs, so the combinevalues resutls returns the delimiter only.  How do I not retu...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous 

Try the folllowing and add an IF statment

IF(combinevalues(", ", if statement, if statement, if statement, if statement, if statement, if statement) = ",,,,",
BLANK(), combinevalues(", ", if statement, if statement, if statement, if statement, if statement, if statement))

This will put a blank insted of ",,,,".

You can replace the BLANK() with "" if needed, for an empty string/text.

 

Good Luck!
A

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks AClerk, I get that, the thing is I want to specifically not do it that way because doesn't it then need to process twice?  When hitting a bunch of records, that seems like I'm doubling my resource usage.

 

Isn't there a method of testing the result afterwards, like if(result = ",,,", "", result) ?