Answered

formula doubt

(0) Share

Report

Posted on by alessandramaced

308

I have this formula to sum several itens in sharepoint list. But Look Up sum only the first register. I need to sum all registers with same Cod_UA (there are more than one). I need to use FIlter? How to do it with all this columns?

LookUp(INTEGRANTES;Cod_UA=ThisItem.Cod_UA;Sum(OFICIAL_DE_PROMOTORIA_CHEFE;OFICIAL_DE_PROMOTORIA_I;AUXILIAR_DE_PROMOTORIA_CHEFE;AUXILIAR_DE_PROMOTORIA_ENCARREGADO;AUXILIAR_DE_PROMOTORIA_I;AUXILIAR_DE_PROMOTORIA_II;AUXILIAR_DE_PROMOTORIA_III;ANALISTA_DE_PROMOTORIA_I;ANALISTA_DE_PROMOTORIA_II;ANALISTA_JURIDICO_DO_MP;ANALISTA_TECNICO_CIENTIFICO_DO_MP;'ANALISTA_DE_PROMOTORIA_I_(SAUDE)';DIRETOR_DE_AREA_DO_MP;DIRETOR_DE_DEPARTAMENTO_DO_MP;ASSESSOR_DE_DIRECAO_DO_MP;ASSESSOR_DE_GABINETE_DO_MP;ASSESSOR_DO_MP;ASSESSOR_ESPECIAL_DO_MP;ESTAGIARIOS_DE_GRADUACAO;ESTAGIARIOS_DE_NIVEL_MÉDIO;PROCURADOR_DE_JUSTICA;PROCURADOR_GERAL_DE_JUSTICA;PROMOTOR_DE_JUSTICA;PROMOTOR_DE_JUSTICA_SUBSTITUTO;SECRETARIO_DO_MP))

Thanks for help

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Joel CustomerEffective 3,224 on at

Like (1)

Report
Copy link

Link copied!

You posted the same question last week, and I answered it here. https://powerusers.microsoft.com/t5/Building-Power-Apps/Doubt-with-formula/m-p/633741

did my solution not work? Please don't double post the same questions.

Was this reply helpful? Yes No
alessandramaced 308 on at

Like (0)

Report
Copy link

Link copied!

I change my data. You said to use Look Up, it will return only 1 data correct?

I need to sum all datas with same ID.
I can use Look Up for this too?

Was this reply helpful? Yes No
PowerAddict 7,316 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Which column do you want to add? Here is a general example:

Sum(Filter(DataSource, Condition), Column1)

Let me know if this helps.

---
If you like this reply, please give kudos (Thumbs Up). And if this solves your problem, please mark this reply as a solution by selecting Accept as Solution. This makes it easier for others to find answers to similar questions.

Thanks!

Hardit Bhatia

Microsoft Business Applications MVP

Blog | Twitter | LinkedIn | Facebook | YouTube | Email

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Do you want to calculate the total value for all registers against on the OFICIAL_DE_PROMOTORIA_CHEFE, OFICIAL_DE_PROMOTORIA_I, ... columns?

Based on the needs that you mentioned, I agree with you, the LookUp function could not achieve your needs. I have made a test on my side, please try the following formula:

Sum( Filter( INTEGRANTES; Cod_UA = ThisItem.Cod_UA ); OFICIAL_DE_PROMOTORIA_CHEFE + OFICIAL_DE_PROMOTORIA_I + AUXILIAR_DE_PROMOTORIA_CHEFE + AUXILIAR_DE_PROMOTORIA_ENCARREGADO + AUXILIAR_DE_PROMOTORIA_I + AUXILIAR_DE_PROMOTORIA_II + AUXILIAR_DE_PROMOTORIA_III + ANALISTA_DE_PROMOTORIA_I + ANALISTA_DE_PROMOTORIA_II + ANALISTA_JURIDICO_DO_MP + ANALISTA_TECNICO_CIENTIFICO_DO_MP + 'ANALISTA_DE_PROMOTORIA_I_(SAUDE)' + DIRETOR_DE_AREA_DO_MP + DIRETOR_DE_DEPARTAMENTO_DO_MP + ASSESSOR_DE_DIRECAO_DO_MP + ASSESSOR_DE_GABINETE_DO_MP + ASSESSOR_DO_MP + ASSESSOR_ESPECIAL_DO_MP + ESTAGIARIOS_DE_GRADUACAO + ESTAGIARIOS_DE_NIVEL_MÉDIO + PROCURADOR_DE_JUSTICA + PROCURADOR_GERAL_DE_JUSTICA + PROMOTOR_DE_JUSTICA + PROMOTOR_DE_JUSTICA_SUBSTITUTO + SECRETARIO_DO_MP )

If you just want to sum one Number column of all matching records with same Cod_UA value in your SP List, please consider try the following formula:

Sum( Filter( INTEGRANTES; Cod_UA = ThisItem.Cod_UA ); NumberColumn )

Please try above solution, check if the issue is solved.

Regards,

Was this reply helpful? Yes No
alessandramaced 308 on at

Like (0)

Report
Copy link

Link copied!

Perfect

Thank you very much

Was this reply helpful? Yes No