Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
Try
avg ({<oDate={">=$(=date(vStart,'DD/MMM/YYYY'))"},oDate={"<=$(=date(vEnd,'DD/MMM/YYYY'))"}>} [Brand Perception])
Try with this:
=Avg(DISTINCT {<oDate={">=$(=date(vStart,'DD/MMM/YYYY'))<=$(=date(vEnd,'DD/MMM/YYYY'))"}>} [Brand Perception])
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])
which is the expected result?
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.
Sorry guys,
I found the problem. the expression is good.