Forum Discussion
Calculo
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...
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 01Hi Anonymous ,
REMOVAL = calculate(sum("DAYS AWAY"), allexpect('table', table'Name')
Regards,
Gaurav Raj Singh
- 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.
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 Anonymous ,
REMOVAL = calculate(sum("DAYS AWAY"), allexpect('table', table'Name')
Regards,
Gaurav Raj Singh
- 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.