set analysis

[#1]

Hi,

I'm starting with set analysis.

I did a formula  = Sum ({<[Fiscal Year-Month]={"2012/05"}>}[Commit Demand])/1000

It's working.

I try to replace {"2012/05"} by a field and it's not working.

= Sum ({<[Fiscal Year-Month]=[Current Fiscal Year-Month]>}[Commit Demand])/1000

= Sum ({<[Fiscal Year-Month]={[Current Fiscal Year-Month]}>}[Commit Demand])/1000

Someone can help me?

Thanks.

Eva

[Jason_Michaelides]

Hi Eva,

Try:

= Sum ({<[Fiscal Year-Month]={$(=Only([Current Fiscal Year-Month])}>}[Commit Demand])/1000

Hope this helps,

Jason

[#3]

Hi Jason,

Thanks for your answer, Unfortunately, It's not working neither :'(

It tried your formula

= Sum ({<[Fiscal Year-Month]={$(=Only([Current Fiscal Year-Month])}>}[Commit Demand])/1000

tihs one :

= Sum ({<[Fiscal Year-Month]={$(=Only([Current Fiscal Year-Month]))}>}[Commit Demand])/1000

and

=Only([Current Fiscal Year-Month]) give the right value.

[#4 · Accepted solution]

= Sum({<[Fiscal Year-Month]= {"$(=Only([Current Fiscal Year-Month]))"} >}[Commit Demand])/1000

[Jason_Michaelides]

Isn't that the same as the answer I gave you?

[#6]

I jsut added from yours

Sum({<[Fiscal Year-Month]= {"$(=Only([Current Fiscal Year-Month]))"} >}[Commit Demand])/1000

[Jason_Michaelides]

Ah.