cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Super User
Super User

Re: Count text values across muliple columns for each row

Could you show me the screen shot of your custom column
tgjones43 Regular Visitor
Regular Visitor

Re: Count text values across muliple columns for each row

Sure, here it is

 

CustomColumnScreenshot.PNG

Super User
Super User

Re: Count text values across muliple columns for each row

@tgjones43 

 

You need to place the formula, I provided above in a new custom column as shown in pic below

 

cf.png

tgjones43 Regular Visitor
Regular Visitor

Re: Count text values across muliple columns for each row

@Zubair_Muhammadthat has done it, thank you so much.

 

Why does the formula need to be presented like that, rather than on one line like I had it?

Super User
Super User

Re: Count text values across muliple columns for each row

Hi @tgjones43 

The formula bar shows the Complete M Code for the step.
The Custom Column just shows the formula part

 

You can also view the entire code for the Query from View Tab>>Advanced Editor.