Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I was hoping someone would help me with a challenge I am facing.
I am trying to sum ActualVolume for Where _Calendar_RollMonthSort is not 13 and CalendarYear is not 2019 and right(Calendar_RollMonthName,1) is not 'A'.
Example If([_Calendar_RollMonthSort] <> '13' AND CalendarYear <> 2019 AND right(Calendar_RollMonthName,1) <> 'A', SUM({<CalendarCurrRolling13Mo={1}>}ActualVolume)/1000)
However it is not working as planned as it looks at [_Calendar_RollMonthSort] <> '13' and excludes both records. Then the next part "CalendarYear <> 2019 " excluded all with the year 2019 ect.
I need it to only exclude if all conditions are true.
Your help would be appreciated
I have also tried using: SUM({<CalendarCurrRolling13Mo={1}, _Calendar_RollMonthSort] -= {'13'}, CalendarYear -= {'2019'} , Right([_Calendar_RollMonthName],1) -= {'A'}>} _ActualVolume)/1000
With no luck
try below
SUM({<CalendarCurrRolling13Mo={1},[_Calendar_RollMonthSort]-={'13'},CalendarYear-={2019} , Calendar_RollMonthName={"=right(Calendar_RollMonthName,1) <> 'A'"}>}ActualVolume)/1000
Kush, thank you for the code. However I loos records I don't want to lose.
In the image below, I have highlighted the record I actually want to exclude:
Would you be able to share sample?