Get possible field issue

[mayankraoka]

Hi All,

I am having issue to get possible fielid value.

In my scenario,I have  sales metric which is visible only when my customer is XYZ. So that I am checking in if condition for all the possible values XYZ is associated then only we get the value.

I am aware of function getpossiblecount but it gives only count there is no function like get-possiblevalue for that field .

Can anyone tell me the way I can check the condition?

Regards,

Mayank

[Anonymous]

Hi

Are you looking for  Possible selection with set analysis  !!!?

Sum({<customer = P({$} XYZ )>} sales) 

[mayankraoka]

Sorry for the confusion.

In this case this will filter only for XYZ data.I need that data which has at-least XYZ as customer.

[sunny_talwar]

Get possible value can be replicated using Concat() function, but you will need to clarify what exactly are you trying to get

[mayankraoka]

Hi Sunny,

Can you tell me How it can be done.

Attached app for your reference.Consider the case for Market metrics.I want to show this if associated CM (Filed) have possible value more than 2 along with HOF(Value)

Regards,

Mayank !

[sunny_talwar]

I am not sure what you are looking to get. Can you elaborate on the required output?

[mayankraoka]

Let me explain you the scenario.

In this use case ,I have confidentiality rule.In which I can show sales value only if it is associated to more than 1 enterprises,otl_cnt should be more than 3 and CM should be more than 2(But HOF should always be there)

by below expression I am able to achieve all the 3 conditions except how I will check that selections are having possible value of CM=HOF?

if(Count(DISTINCT CM)>2 and Count(DISTINCT ENTERPRISE)>1 and max(OTLT_CNT)>2,Sum( {<CM=>}sales),'NA'))

Let me know if you need any futher information .

Regards,

Mayank

[mayankraoka]

Can anyone help me on this?

[sunny_talwar]

May be check like this:

SubStringCount(Concat(DISTINCT '|' & CM & '|', ','), 'HOF') = 1

[mayankraoka]

I think I have found the answer to the question thank you all for your reply.

Regards,

Mayank