topic Re: New to Set Analysis - Expression failing in App Development

New to Set Analysis - Expression failing

WiscoSippi — Tue, 28 Jun 2016 16:55:23 GMT

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

sunny_talwar — Tue, 28 Jun 2016 17:01:07 GMT

How is $(vPeriodCurrentMonth) defined?

Re: New to Set Analysis - Expression failing

WiscoSippi — Tue, 28 Jun 2016 18:04:09 GMT

Updated with actual definition:

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

Re: New to Set Analysis - Expression failing

sunny_talwar — Tue, 28 Jun 2016 18:13:58 GMT

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

WiscoSippi — Tue, 28 Jun 2016 18:18:07 GMT

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!