Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Count and %

Hello,

I have this expression:

     Count({$<DateType={Agendada}>}Remision.numrem)

And I have this Pivot Table

Pivot Table.png

The column called "Contador" is the one that contains the expression... now... in a new colum I want to get a percentage of each single row of "ServicioC" compared to the total of each row of column "Medico"

How can I do that? Is kind of confusing for me.

Thanks a lot!

1 Solution

Accepted Solutions
johnw
Champion III
Champion III

I think this?

=count({<DateType={'Agendada'}>}                Remision.numrem)
/count({<DateType={'Agendada'}>} total <Medico> Remision.numrem)

View solution in original post

1 Reply
johnw
Champion III
Champion III

I think this?

=count({<DateType={'Agendada'}>}                Remision.numrem)
/count({<DateType={'Agendada'}>} total <Medico> Remision.numrem)