New to Set Analysis - Expression failing

[WiscoSippi]

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

[sunny_talwar]

How is $(vPeriodCurrentMonth) defined?

[WiscoSippi]

Updated with actual definition:

	{<
	[Fiscal Period Counter Month] = {"$(=max([Fiscal Period Counter Month]))"}
	>}

[sunny_talwar · Accepted solution]

Try this:

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

[WiscoSippi]

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!