Multiple If condtions with aggregate function - error

[Pragya]

Hi There ,

I am trying to put two-three conditions in if statement and facing error.

So If I write

 SUM(if ([Arrival Year] <> 2020, Area_Resident))  / Sum(Population) *100000 ( works fine)

when I write

 SUM(if ([Arrival Year] <> 2020 and [Arrival Month] <> {'July'}, Area_Resident))  / Sum(Population) *100000 , I get error.

Could anyone suggest please ?

My aim is to use 2-3 conditions  in expression editor for one of the graph please

[Kushal_Chawda · Accepted solution]

@Pragya  try below set analysis

 SUM({<[Arrival Year] -={'2020'} , [Arrival Month] -={'July'}>}Area_Resident))  / Sum(Population)*100000