Using set identifier with multiple set analysis

Mon, 12 Sep 2016 21:08:04 GMT

Maybe its just the syntax that's screwing me up. My issue is i want to do the set analysis say for Year=2016, and Month=Jul, exluding all selections.

Sum({1<[Year]={'2016'}>*<[Month]={'Jul'}>}Sales)

This behaves the same way with or without the 1. The year and month sets work on their own, and if i combine the 1 with only one field of set analysis it works, but not all at the same time.

Any Ideas?

Thanks

Re: Using set identifier with multiple set analysis

sunny_talwar — Mon, 12 Sep 2016 23:43:17 GMT

Try this:

Sum({1<[Year]={'2016'}, [Month]={'Jul'}>}Sales)

topic Re: Using set identifier with multiple set analysis in App Development

Using set identifier with multiple set analysis

Re: Using set identifier with multiple set analysis