Calculo

[marcotsousa]

Boa tarde!

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

NOME                 CID              DIAS AFASTAMENTO

Jose Castro          A                         03

Chico Fulano       B                          01

Joana Sa              A                          05

Total

CID        DIAS AFASTAMENTO

A                       08

B                        01  

[Anonymous · Accepted solution]

English translation :

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 example

NAME CID DAYS AWAY 
Jose Castro A 03 
Chico Fulano B 01 
Joana Sa A 05   

Total 

CID DIAS REMOVAL 
A        08 
B        01

Hi @marcotsousa  ,

REMOVAL = calculate(sum("DAYS AWAY"), allexpect('table', table'Name')

Regards,

Gaurav Raj Singh

LinkedIN    https://www.linkedin.com/in/gauravrajsingh/

[Anonymous · Accepted solution]

English translation :

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 example

NAME CID DAYS AWAY 
Jose Castro A 03 
Chico Fulano B 01 
Joana Sa A 05   

Total 

CID DIAS REMOVAL 
A        08 
B        01

Hi @marcotsousa  ,

REMOVAL = calculate(sum("DAYS AWAY"), allexpect('table', table'Name')

Regards,

Gaurav Raj Singh

LinkedIN    https://www.linkedin.com/in/gauravrajsingh/

[Anonymous · Accepted solution]

Simple measure sum(table[column]) will work.

Drag name column and this measure in visual.


Thanks
Pravin

If it resolves your problem mark it as a solution and give Kudos.