Expression

[smilingjohn]

if(DRGRSLT='Soap' ,count(distinct ID)*.35,'')

In Above expression  I am considering only "Soap" from the field Lead,

How do i write a expression  where upon i can select anything from the field ?

For exmaple :

if(Lead='*' ,count(distinct ID)*.35,'')     Which is not working ?

and also i want to condier two fields

if(Lead='Soap', andif(product='*'  ,count(distinct ID)*.35,'')

Can someone please throguth some light on this

[Kushal_Chawda · Accepted solution]

like this?

count(distinct {<Lead={'*'}>} ID)*0.35

or

count(distinct {<Lead={'Soap'},Product={'*'}>} ID)*0.35

[sunny_talwar]

I have no idea what you are trying to do here, is there a sample you can share with the expected output?

[Chanty4u]

is this may be

count(distinct{<lead={'*'}>}id)*0.35

?

[Anonymous]

Is their any difference b/w your expression and this?

'*' means every thing, is this really required to pass in SET?

=count(Distinct ID)*0.35

or

=count({<Lead={'Soap'}>} ID)*0.35

[sunny_talwar]

When you add this -> {'*'} in ignore null

Sum({<Country = {'*'}>} Sales) can be different from Sum(Sales) if there are places where Country is null.

[sasiparupudi1]

Try the following

count(distinct {1<lead={'*'}>}ID)*.35

[Anonymous]

Putting '*' means it will ignore null, Is it?

[sunny_talwar]

Yes

[Anonymous]

Okay, have not obsereved it earlier

Thanks for clarification