Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I would like to get the SUM of UNITS, if the RECEIPT DATE is equal to 'Jan'.
To get the Month of the date, i know it should be
Month([RECEIPT DATE])
But it seems below formula is not correct, can anyone please help?
Sum({$<month([Receipt Date])={'Jan'}>} [Units])
Perhaps these?
Sum(if(month(date)='jan', units))
Or
Sum({<date={"= month(date)='jan'"}>} units)
And I would always think
Sum({<monthfield={'jan'}>} units) where as monthfield is created in script if month field and date field are associated.
Perhaps these?
Sum(if(month(date)='jan', units))
Or
Sum({<date={"= month(date)='jan'"}>} units)
And I would always think
Sum({<monthfield={'jan'}>} units) where as monthfield is created in script if month field and date field are associated.