Expression Syntax...

[Anonymous]

Hello,

What is the error in this syntax:

=Count({<[@Lead_Lead Type] = {"Student"}, @Lead_Status={"Submitted"}>}DISTINCT(%LEADID))

Its not working, giving all values 0.

pls suggest.

[amit_saini]

Hi,

The correct syntax is count(distinct Staff_Name)

Try with this.

Thanks,
AS

[tresesco]

Syntax seems good. Problem could possibly be somewhere else. Can you share your sample qvw?

[Anonymous]

Tresco,

If I remove @Lead_Status from Set, its work fine.

But I have to add one expression which will show total forms....any other syntax?

[its_anandrjs]

Try this expression

=Count(DISTINCT {<[@Lead_Lead Type] = {'Student'}, [@Lead_Status] = {'Submitted'}>} [%LEADID] )

Note:- Also check your field name weather it is correct that you use expression seems correct.

Regards

Anand

[tresesco]

  If I remove @Lead_Status from Set, its work fine.

That means there is no data for the combination - [@Lead_Lead Type] = "Student" And @Lead_Status="Submitted"

Select lead type 'Student' in the list box, you probably won't see lead status 'Submitted' in the white(possible) color.

[Anonymous]

No,

Data is their. If I use [@Lead_Lead Type] = "Student" only and then selecting "Form" from list box its working fine and giving me correct data.

But If I m putting it into expression, its not working....

[SunilChauhan]

Count(DISTINCT {<[@Lead_Lead Type] = {'Student'}, [@Lead_Status] = {'Submitted'},fieldname={'Form'}>} [%LEADID] )

[tresesco]

Can you share your sample qvw that demonstrates the issue(with explanation)?

[PrashantSangle]

Hi,

Debug your expression by trying following steps

Take @Lead_Lead Type,@Lead_Status,%LEADID in list box

select @Lead_Lead Type list box select Student and

@Lead_Status list box selct Submitted and then check

Is there any value in %LEADID list box.

and if possible kindly post those screen shot with selected parameter or share data with sample qvw

Regards