Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Month | Total | Percentage |
---|---|---|
January | 100 | 100% |
Process1 | 60 | 60% |
Process2 | 40 | 40% |
February | 200 | 100% |
Process1 | 80 | 40% |
Process2 | 120 | 60% |
Thank you
Try this... notice how I don't have curly brackets before < and after >
Count(ID_CASO)/Count(TOTAL<MONTH_FECHA_CREACION_SINHORA> ID_CASO)
It Works!
Thank you