Calculo

Question

Boa tarde!&nbsp;Tenho uma planilha que consta atestados médicos de empregados organizados por Letra de CID (sigla) e dias de afastamento. Preciso de calcular qtos dias de afastamento pra cada letra de CID, por exemplo&nbsp;NOME&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DIAS AFASTAMENTOJose Castro&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;03Chico Fulano&nbsp; &nbsp; &nbsp; &nbsp;B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01Joana Sa&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 05&nbsp;TotalCID&nbsp; &nbsp; &nbsp; &nbsp; DIAS AFASTAMENTOA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;08B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01&nbsp;&nbsp;&nbsp;

anonymous · Accepted Answer

English translation :&nbsp;&nbsp;Good afternoon!I have a spreadsheet that contains medical certificates of employees organized by Letter of CID (acronym) and days of absence.I need to calculate how many days off for each letter of CID, for exampleNAME CID DAYS AWAY Jose Castro A 03 Chico Fulano B 01 Joana Sa A 05 &nbsp; Total CID DIAS REMOVAL A        08 B        01&nbsp;Hi&nbsp;Anonymous&nbsp; ,&nbsp;REMOVAL = calculate(sum("DAYS AWAY"), allexpect('table', table'Name')&nbsp;Regards,Gaurav Raj SinghLinkedIN&nbsp; &nbsp; https://www.linkedin.com/in/gauravrajsingh/

Forum Discussion

Calculo

2 Replies

Related content

Calculo en blanco de la medida DAX PEND FIN MES II

Calculo de Kardex

Calculo de Cuartiles

Calculo promedio agrupado por proyecto

Calculo de disponibilidad mantenimiento