Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
vbravomo
Contributor III
Contributor III

Relative percentage

Hello,

I've used  Count({<Process,Date>}ID_CASE)/Count(total{<Process,Date>}ID_CASE) but the percentage that I get is over the total amount, and I need to get a percentage per the total of each month. I meant I need to get this table.

MonthTotalPercentage
January

100

100%
Process16060%
Process24040%
February200100%
Process18040%
Process212060%

Thank you

11 Replies
sunny_talwar

Try this... notice how I don't have curly brackets before < and after >

Count(ID_CASO)/Count(TOTAL<MONTH_FECHA_CREACION_SINHORA> ID_CASO)


Capture.PNG

vbravomo
Contributor III
Contributor III
Author

It Works!

Thank you