Whats wrong in this count and if expression ?

Sat, 06 Apr 2013 07:30:49 GMT

Expression for 0-1:

=count(if(Status='Open' and [As On Date]-[Commissioning Date]<2 ,Status='Closed' and [Closure Date]-[Commissioning Date]<2, [WQMS ID]))

Dimension Status has 2 values 'Open' and 'Closed' .

Obtained Result :

Desired Result:

Data :

Re: Whats wrong in this count and if expression ?

kaushiknsolanki — Sat, 06 Apr 2013 08:12:33 GMT

Try this

= if(Status='Open',

Count(if([As On Date]-[Commissioning Date]<2 ,[WQMS ID])),

if(Status='Closed',

count(if( [Closure Date]-[Commissioning Date]<2 ,[WQMS ID]))))

Regards,

Kaushik Solanki