Percentage Calculation

[sat_tok52]

Hi All,

I have to show percentage based on the visiteddate , I have a column visit-date, so  i have to show visited Account Id percentage like suppose   out 10 Acount Id's  how many id's are visited that percentage and who are not visited that percentage  .Below table Null symbol means not visited id's.

Suppose 7 id's are visited Count(VisitDate)/Count(Distinct AcctID) i.e's 7/10=70%

Suppose 3 id's are Not visited NullCount(VisitDate)/Count(Distinct AcctID) i.e's 3/10=30%

Data:

AcctID	VisitDate
1	10/1/2019
2	10/2/2019
3	10/3/2019
4	-
5	10/5/2019
6	10/6/2019
7	10/7/2019
8	-
9	10/7/2019
10	-

Expected Result:

AcctID	VisitDate	Expected Result
1	10/1/2019	70%
2	10/2/2019	70%
3	10/3/2019	70%
4	-	30%
5	10/5/2019	70%
6	10/6/2019	70%
7	10/7/2019	70%
8	-	30%
9	10/7/2019	70%
10	-	30%

Thanks.

[sunny_talwar · Accepted solution]

May be this

Count(DISTINCT TOTAL {<AcctID = {"=Len(Trim(VisitDate)) > 0"}>} AcctID)
/
Count(DISTINCT TOTAL AcctID)

and

Count(DISTINCT TOTAL {<AcctID = {"=Len(Trim(VisitDate)) = 0"}>} AcctID)
/
Count(DISTINCT TOTAL AcctID)

[sat_tok52]

Hi Sunny,

Thanks for your quick reply.It's working like what i am expecting.

Thanks.