topic Re: Set Analysis: IF year is 2017 full year sales else only dec month sales in App Development

Set Analysis: IF year is 2017 full year sales else only dec month sales

rammarthi — Sat, 19 Aug 2017 13:25:28 GMT

Hi,

If Year is 2017, we should have full year sales else we should get only dec month sales for any other year selected.

Thanks in Advance.

vinieme12 — Sun, 20 Aug 2017 12:30:34 GMT

if( Year = 2017 , SUM({<Year={2017}>} SALES)

,SUM({<Month={12}>} SALES)

)

sunny_talwar — Sun, 20 Aug 2017 12:55:38 GMT

May be this

RangeSum(

Sum({<Year = {$(=Year(Today()))}>}Measure),

Sum({<Year = {$(='<' & Year(Today()))}, Month = {'Dec'}>}Measure)

)