Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
can any one help me to get the expression to find the count,
I have a table like below , if a person has active Product sales less than 3000 for consecutive dates then count is 1 if not count is zero.
how to achieve this with set analysis.
Edited:
Expected Result is
A | 2 |
B | 1 |
C | 1 |
D | 1 |
Date | Active Productsales | Person |
3/16/2013 | 1100 | A |
3/17/2013 | 2500 | A |
3/18/2013 | 2000 | B |
3/19/2013 | 2000 | B |
3/20/2013 | 2000 | A |
3/21/2013 | 3500 | B |
3/22/2013 | 2900 | A |
3/23/2013 | 2500 | A |
3/24/2013 | 2500 | C |
3/25/2013 | 2500 | C |
3/26/2013 | 3250 | D |
3/27/2013 | 2500 | D |
3/28/2013 | 2640 | D |
3/29/2013 | 2500 | D |
3/30/2013 | 6000 | C |
3/31/2013 | 4200 | D |
Hi
=count({<ActiveProductSales={'<3000'}>}Person)
try this
Check
Hope this is what you expect
Hi sorry try this:
=count(DISTINCT {< ActiveProductSales={'<3000'} >}Person)
Thanks Padmanabhan Ramakrishnan.
No it is not working, and it is not checking consecutive dates , if I change the below product sales value to 1500 count should be 2 for A, but it is not showing it.
3/16/2013 | 5000 | A |
Thanks Amarnath Prajapati,
No it is not working, and it is not checking consecutive dates , if I change the below product sales value to 1500 count should be 2 for A, but it is not showing it.
3/16/2013 | 5000 | A |
Hi,
Try this in the expression of the straight table,
=If(Above(Num(If(Sum([Active Products])<3000,Day(Date))))+1=Day(Date),1,0)
See attached,
You can hide the date column in the table finally.
Thanks Malini Chandrasekar,
No it is not working, and it is not checking consecutive dates , if I change the below product sales value to 1500 count should be 2 for A, but it is not showing it.
3/16/2013 | 5000 | A |
and I want out put like above, I don't want to see the repeated persons.
Hi,
Please find the attached app.
Regards
Krishna