find sum of ACount and BCount using SetAnalysis and Variables

[khasimvali85]

find sum of ACount  and BCount using SetAnalysis and Variables

i have Tables like

ComplaintDate  ComplaintNo                   ACount           BCount     ID   

12/03/2014         AGR130320140154           N                   1          56342

13/03/2014         DEL150320140155            N                   1          56343

14/03/2014         UPR160320140156            N                   1          56344

01/04/2014        AND020420140160             N                   1          56345   

15/04/2014         KER170420140162            Y                   1          56347

25/04/2014         PUN260420140163            Y                   1          56350

My Requirement is

1, only 'N' Values Count in (Total of ACount)

2,  BCount Using Set Analysis and Variables,

3, If i want to select one Date in Calender Table disply Previous 3 days Dates.

[swuehl · Accepted solution]

I am not sure I fully understand your requirements (so it would be helpful if you add your expected outcome to above sample), but here are some possible answers:

1)

=count(if(ACount = 'N', ACount))

or

=count({<Acount = {'N'}>} ACount)

2) ???

Sorry, don't understand your req.

3) ???

Sorry, don't understand your req. Where do you want to display what data when selecting a date?

[khasimvali85]

Hi Swuehl,

Thanks for your Answer

2, B Count is also Same but using Set Analysis and Variables

3, i want to display   for example if i select one Date like 04/06/2014 i want to display 3 previous days is 03/06/2014 , 02/06/2014, 01/06/2014 using set analysis and variables  

Regards

Khasim.

[khasimvali85]

3rd Requirement is i want display like this

           01/06/2014                                               02/06/2014                                 03/06/2014

Acount  Bcount ACount% BCount%  ACount  BCount   ACount%  BCount%  ACount BCount ACount%BCount%

Regards

Khasim.

[Anonymous]

Three previous days count would be:

count({1<CompliantDate={"$(='>=' & date($(vDate)) & '<=' & date($(vDate)-2))"}>} WhateverYouCountHere)

where vDate is a variable contining the selected date.  If always one date is selected, it is
=CompliantDate
If multiple dates are selcted, you maybe need the earliest one:
=date(min(CompliantDate))
or the latest:
=date(min(CompliantDate))

[khasimvali85]

Thanks Michael