4 Replies Latest reply: Jun 28, 2016 2:18 PM by Benjamin Wildmon

# New to Set Analysis - Expression failing

Here's the expression:

sum(\$(vPeriodCurrentMonth),{\$<[LTC Type] = e({<[LTC Type]={' '}>} [LTC Type])>} [Prod Lbr Hrs])

Modifier 1 = \$(vPeriodCurrentMonth)

Modifier 2 = {\$<[LTC Type] = e({<[LTC Type]={' '}>} [LTC Type])>}

I've verified that each modifier works independently but they wont work together. Any help on how to get them to work together would be appreciated!

Thanks!

Ben

• ###### Re: New to Set Analysis - Expression failing

How is \$(vPeriodCurrentMonth) defined?

• ###### Re: New to Set Analysis - Expression failing

Updated with actual definition:

 {< [Fiscal Period Counter Month] = {"\$(=max([Fiscal Period Counter Month]))"} >}
• ###### Re: New to Set Analysis - Expression failing

Try this:

Sum({\$<[Fiscal Period Counter Month] = {"\$(=max([Fiscal Period Counter Month]))"}, [LTC Type] = e({<[LTC Type]={' '}>} [LTC Type])>} [Prod Lbr Hrs])

• ###### Re: New to Set Analysis - Expression failing

I had to modify it to this:

Sum({\$<[Fiscal Period Counter Month] = {\$(=max([Fiscal Period Counter Month]))}, [LTC Type] = e({<[LTC Type]={' '}>} [LTC Type])>} [Prod Lbr Hrs])

basically, just removed the quotes around =max and then had to relink the field names. Thanks!