different expression for different dimension and month

[Anonymous]

Hi,

I have different groups in a table as dimension. and in my expression i sum points. But for one group i want to sum points*0.7 if the point was registred any month exept june july or august. Otherwise it's jus sum(points).

Who do i write this in my expression to get i to work.

It's the month part i'm having problem with. This works fine:

if(Team='groupX', avg(aggr(count({$<points={'>0'}>} distinct person), date, group))*0.7,

avg(aggr(count({$<points={'>0'}>} distinct person), date, group))

)

//A.

[#2]

Have you tried something like this:

if(Team='groupX' AND Month <> 'June' AND Month <> 'July' AND Month <> 'August', avg(aggr(count({$<points={'>0'}>} distinct person), date, group))*0.7,

avg(aggr(count({$<points={'>0'}>} distinct person), date, group))

)

[Anonymous]

no didn't work. still got the same result as the above one. despite different month selections

[rrsrini2907]

Hi,

Could you upload sample.

Regards,

Srini.

[Anonymous]

I's woking when a chose one of these special months but if a pick a period between may and oktober the number are the same as the expression i described that worked.