Set analysis issue

[Anonymous]

Hi guys,

I can't understand what wrong with my expression

Avg({<oDate={">=$(=date(vStart,'DD/MMM/YYYY'))<=$(=date(vEnd,'DD/MMM/YYYY'))"}>} [Brand Perception])  is?

Please see my attached file.

Thanks,

[richard_pearce6]

Try

avg ({<oDate={">=$(=date(vStart,'DD/MMM/YYYY'))"},oDate={"<=$(=date(vEnd,'DD/MMM/YYYY'))"}>} [Brand Perception])

[#3]

Try with this:

=Avg(DISTINCT {<oDate={">=$(=date(vStart,'DD/MMM/YYYY'))<=$(=date(vEnd,'DD/MMM/YYYY'))"}>} [Brand Perception])

[its_anandrjs]

I dont believe there is any error might be try like

=Avg({<oDate={">=$(=date(date#(vStart,'DD/MMM/YYYY')),'DD/MMM/YYYY')<=$(=date(date#(vEnd,'DD/MMM/YYYY')),'DD/MMM/YYYY')"}>} [Brand Perception])

or may be this

=Avg(DISTINCT {<oDate={">=$(=date(date#(vStart,'DD/MMM/YYYY')),'DD/MMM/YYYY')<=$(=date(date#(vEnd,'DD/MMM/YYYY')),'DD/MMM/YYYY')"}>} [Brand Perception]) 

[#5]

which is the expected result?

[Anonymous]

The expression is correct, works fine as it is.

Not sure though what you're trying to do with it in your application.  But this should be a different question.

[Anonymous]

Sorry guys,

I found the problem. the expression is good.