Formula Text Issue
Not sure what I'm doing wrong but the formula below isn't passing the numeric value I think it would. To set the stage: Variable [Channel43] = Broadband Back Office Variable [Channel46] = Video B...
Forum Discussion
Morning Mark,
Okay, that formula is based entirely on 3 fields. There is the:
Here is variable Channel 43:
Here is variable - Channel 46:
I've spot checked spelling, I've validated the delimiter, and I've verified no extra spaces. I just wonder if I should use the actual text instead of variables and see if that resolves the issue?
------------------------------
Michael Sargent
------------------------------
Okay, that formula is based entirely on 3 fields. There is the:
- IntakeID - Channel Summary
- Variable - [Channel43]
- Variable - [Channel46]
| IntakeID - Channel Summary |
| Broadband Back Office;Video Back Office |
Here is variable Channel 43:
Here is variable - Channel 46:
I've spot checked spelling, I've validated the delimiter, and I've verified no extra spaces. I just wonder if I should use the actual text instead of variables and see if that resolves the issue?
------------------------------
Michael Sargent
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendPerhaps there is a trailing space after the text in ([IntakeID - Channel Summary])
IF(
Trim([IntakeID - Channel Summary])=[Channel46], "4",
Trim([IntakeID - Channel Summary])=[Channel43], "3",
Trim([IntakeID - Channel Summary])=List(";",[Channel43],[Channel46]), "2",
Contains(Trim([IntakeID - Channel Summary]),[Channel43]), "1",
Contains(Trim([IntakeID - Channel Summary]),[Channel46]), "1", "0")
also when you said this
I presume that the data is really this
Broadband Back Office;Video Back Office
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
IF(
Trim([IntakeID - Channel Summary])=[Channel46], "4",
Trim([IntakeID - Channel Summary])=[Channel43], "3",
Trim([IntakeID - Channel Summary])=List(";",[Channel43],[Channel46]), "2",
Contains(Trim([IntakeID - Channel Summary]),[Channel43]), "1",
Contains(Trim([IntakeID - Channel Summary]),[Channel46]), "1", "0")
also when you said this
| IntakeID - Channel Summary |
| Broadband Back Office;Video Back Office |
I presume that the data is really this
Broadband Back Office;Video Back Office
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- Well, i have some bad news and promising news. As for the bad news, the formula wouldn't take the TRIM function based on field type. So then I got creative. I knew the functions of the formula (ToText(Intake ID - Channel Summary) & List(";",[Channel43],[Channel46]). Since obviously the two weren't equal, i wanted to see what the different was. So, i created temporary fields with just those formulas. And wouldn't you know, they don't match. You can see that the totext(IntakeID - Channel Summary) appears to have a space before and after the semicolon.
Record ID# IntakeID Temporary (IntakeID - Channel Summary) - ToText Temporary - Broadband & Video B/O List 4746 34,280 Broadband Back Office ; Video Back Office Broadband Back Office;Video Back Office
So, the question I now have is whether the List function allows for specificity. Meaning can I write it list List(";",[Channel43] , [Channel46]) so it matches the space in the ToText value?
------------------------------
Michael Sargent
------------------------------- Resolved. Just changed the List function to include the preceding and following spaces next to the semicolon. (e.g. List(" ; "....) Now it works like a charm. Thanks for helping me troubleshoot this one.
------------------------------
Michael Sargent
------------------------------