Disregard month selection

[#1]

Hello!

I want to disregard the month selection and have following formula,

sum({$<Month=>} aggr((Sum(amount_NR)/Sum(Count_nr))*Sum(Count_NB) * Sum(Days) / 7 / Procentamount, Counting_opps,))

Despite that I have {$<Month=>} it still changes data when I select different months. I have loaded a calendar which have month as dimension and is connected to the facts table via Date field. 

Need som help so figure this out.

Best regards

Mårten

[sunny_talwar]

Try putting {$<Month =>} for everytime you use Sum in your expression. May be like this:

=Sum({$<Month=>} Aggr((Sum({$<Month=>} amount_NR)/Sum({$<Month=>}Count_nr)) * Sum({$<Month=>}Count_NB) * Sum({$<Month=>}Days) / 7 /Procentamount, Counting_opps))

[rubenmarin · Accepted solution]

Hi Marten, you'll need to add the set analisys expression to each of the Sum() inside the Aggr():

sum({$<Month=>} aggr((Sum({$<Month=>} amount_NR)/Sum({$<Month=>} Count_nr))*Sum({$<Month=>} Count_NB) * Sum({$<Month=>} Days) / 7 / Only({$<Month=>} Procentamount), Counting_opps))

Procentamount will be only one value per Counting_opps? If tehree is more than one value it will return null()

[#4]

Great, now it works.

Thanks!

Best regards

Mårten