If not blank then 1

[alpharaffrobb]

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

[alpharaffrobb]

Yes, Let me try your sample/example.

Thanks

Robb

[N1kh1l]

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]

I getting this error

[Chris_Tam]

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