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

[sunny_talwar]

When HOF is in selection

When HOF is not in selection

Expression used is

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

So when HOF is within the selection bucket, you will see 1, else you will see 0.

Alternatively, you can also try playing with this:

=Count(DISTINCT {<CM *= {'HOF'}>} CM)

[akshayjain90]

Hi Mayank,

Please try the below expression -

=if(sum({$<CT=p({<CM={'HOF'}>}CT)>}sales)>0,1,0)

Regards,

Akshay