on 11-01-2023 8:41 PM
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
Yes, Let me try your sample/example.
Thanks
Robb
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
61 | |
9 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.