how to make Aggr with set analysis

[brijeshvma]

Hi All,

I have one Expression as say : Sum(Aggr(Visits,VisitFull))

and i am making one WTD Condtion in Calander Script :

If( Weekday(Date) <= Weekday(Today()-1), 1, 0) as IsInWTD ...

So i Currently i am putting Sum({<IsInWTD={1}>}Visits) .... But i want Aggr this Expression on VisitFull...

So i want to Use This Set Analysis : {<IsInWTD={1}  In Sum(Aggr(Visits,VisitFull))  Aggre expression...

Kinldy Help me on this

[MK_QSL]

SUM( Aggr(Sum({<IsInWTD={1}>}Visits),VisitFull))

[Chanty4u]

try this

if(sum(aggr(sum({<IsInWTD={1}>}visits),visitfull))

or

sum(aggr(sum({<IsInWTD={1}>}visits),visitfull)

[swuehl]

Or even

SUM({<IsInWTD={1}>} Aggr(Sum({<IsInWTD={1}>}Visits),VisitFull))

Set Analysis in the Aggr function

[ahmar811 · Accepted solution]

hi

Brijesh Maurya‌

try this

expression

=Sum({<IsInWTD={1}>}Aggr(Visits,VisitFull))

hope this help you

Thanks & Regards

Ahmar Ansari

[jonathandienst]

What purpose does the Aggr() serve? In most cases, Sum(Aggr(Sum({.} F1), F2) is the same as Sum(F1) and much more expensive to calculate. If you are trying filter, then rather use something like:

Sum({<F2 = P(F2)>} F1)