cancel
Showing results for 
Search instead for 
Did you mean: 

If not blank then 1

alpharaffrobb
Explorer
0 Kudos

What is formula to add a calculated column when referenced cell is populated with a name or is not blank.

I have customer name in first column and want new column to show count of 1 when there is a name.

Thanks

AlphaRobb

Accepted Solutions (0)

Answers (4)

Answers (4)

alpharaffrobb
Explorer
0 Kudos

Yes, Let me try your sample/example.

Thanks

Robb

N1kh1l
Active Contributor
0 Kudos

alpharaffrobb

I am assuming your customer is a dimension and Customer name is the description of the customer id.

IF(NOT((ISNULL([d/"SAP_CEP_SALES_PLANNING":SAP_CEP_CUSTOMER].[p/ID]))), 1, 0)

Br.

Nikhil

alpharaffrobb
Explorer
0 Kudos

I getting this error

Chris_Tam
Explorer
0 Kudos

Hi alpharaffrobb,

Depending if your customer name is null or and empty string, you can create a calculated dimension using LENGTH() or ISNULL to check if it is blank.

Something like:

IF(ISNULL([d/"2024":"Customer Name"]) OR LENGTH([d/"2024":"Customer Name"].[p/Customer Name]) > 0, 1 , 0 )

Chris