I want to obtain selective sum in a column according to categorization. For example if status is posted the sum of days should only be only of the posted category for all the months.
Applying or, and operators does not solve the problem as either it considers all the condition or only 1.
The logic i used is as follows:
If ('july_status='POSTED' or june_status='POSTED' or may_status='POSTED' or april_status='POSTED' or march_status='POSTED' or feb_status='POSTED' ,
july_days'+june_days' +may_days+ april_days + march_days+ feb_days) as "Total Posted",
The link you shared is not solving our problem.