restar la sumatoria de 2 listas

%3CLINGO-SUB%20id%3D%22lingo-sub-1559732%22%20slang%3D%22es-ES%22%3Esubtracting%20the%20sum%20from%202%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1559732%22%20slang%3D%22es-ES%22%3E%3CP%3ENice%20day%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOn%20a%20SharePoint%20page%20I%20have%20two%20lists.%20Each%20list%20totals%20a%20column%20that%20has%20numeric%20values.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%20to%20subtract%20these%202%20summations%20considering%20that%20they%20are%20from%202%20different%20lists%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22adriancastano_1-1596242457100.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F209508i3725BD726A723CBE%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22adriancastano_1-1596242457100.png%22%20alt%3D%22adriancastano_1-1596242457100.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20the%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1559732%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1559780%22%20slang%3D%22en-US%22%3ERe%3A%20restar%20la%20sumatoria%20de%202%20listas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1559780%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F746451%22%20target%3D%22_blank%22%3E%40adriancastano%3C%2FA%3E%26nbsp%3B%20claro%20que%20si%20es%20posible%20en%20la%20segunda%20list%20en%20tu%20opcion%20de%20suma%20seleccionas%20conseguir%20orbusca%20informacion%20ya%20en%20este%20sitio%20eliges%20la%20columna%20y%20la%20agregas%20a%20la%20formula.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1559808%22%20slang%3D%22en-US%22%3ERe%3A%20restar%20la%20sumatoria%20de%202%20listas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1559808%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F746451%22%20target%3D%22_blank%22%3E%40adriancastano%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERevisa%20este%20enlance%20creo%20que%20te%20puede%20ayudar...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcalculate-data-in-lists-or-libraries-c5261743-667f-4833-bede-e516cef2a0e1%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcalculate-data-in-lists-or-libraries-c5261743-667f-4833-bede-e516cef2a0e1%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1559894%22%20slang%3D%22es-ES%22%3ERe%3A%20subtracting%20the%20sum%20from%202%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1559894%22%20slang%3D%22es-ES%22%3E%3CP%3EGood%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F746126%22%20target%3D%22_blank%22%3Emorning%2C%20%40jnava_19%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20advance%20thank%20you%20very%20much%20for%20responding%20so%20soon.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20been%20analyzing%20the%20two%20answers%2C%20but%20I%20can't%20solve%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20I%20explain%20it%20another%20way%3A%20the%20first%20list%20describes%20a%20contract%20for%204%2C000%2C000%20and%20the%20second%20list%20describes%20one%20payment%20that%20has%20been%20made%20to%20that%20contract%20worth%201%2C000%2C000.%20Well%2C%20the%20list%20views%20I've%20already%20got%20the%20value.%20Now%20what%20I%20require%20is%20that%20the%20user%20who%20comes%20to%20visit%20that%20page%2C%20can%20see%20in%20a%20field%20that%20I%20know%20how%20to%20insert%20on%20the%20page%20in%20SharePoint%20design%20mode%2C%20which%20subtracts%20the%20sum%20of%20the%20contract%20minus%20the%20sum%20of%20the%20payments%20made.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20a%20lot.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1560323%22%20slang%3D%22es-ES%22%3ERe%3A%20subtracting%20the%20sum%20from%202%20lists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1560323%22%20slang%3D%22es-ES%22%3E%3CP%3EGood%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F746126%22%20target%3D%22_blank%22%3Emorning%2C%20%40jnava_19%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20advance%20thank%20you%20very%20much%20for%20responding%20so%20soon.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20been%20analyzing%20the%20two%20answers%2C%20but%20I%20can't%20solve%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20explain%20it%20as%20follows%3A%20on%20a%20page%20I%20have%20in%20SharePoint%20I'm%20displaying%202%20lists.%20The%20first%20list%20describes%20a%20contract%20for%204%2C000%2C000%20and%20the%20second%20list%20describes%20the%20payments%20that%20are%20made%20to%20the%20contract%2C%20for%20this%20example%20a%20payment%20of%201%2C000%2C000%20has%20been%20made.%20However%2C%20the%20list%20views%20are%20already%20totaling%20the%20value.%20What%20I%20require%20is%20that%20the%20user%20who%20comes%20to%20visit%20that%20page%20can%20see%20in%20a%20field%20that%20I%20do%20not%20know%20how%20to%20insert%20in%20SharePoint%20design%20mode%2C%20which%20shows%20the%20difference%20between%20the%20totals%20of%20the%202%20lists.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20solutions%20you%20propose%20make%20a%20summary%20in%20the%20lists%20but%20I%20still%20can't%20show%20the%20visitors%20of%20the%20page%20the%20difference%20between%20these%202%20totals.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20a%20lot.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1560453%22%20slang%3D%22en-US%22%3ERe%3A%20restar%20la%20sumatoria%20de%202%20listas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1560453%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F746451%22%20target%3D%22_blank%22%3E%40adriancastano%3C%2FA%3E%26nbsp%3BI%20think%20this%20could%20be%20achieved%20with%20a%20PowerApps%20customised%20form%2C%20but%20I'd%20have%20to%20do%20some%20experiments.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23333399%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Buen día,

 

En una página de SharePoint tengo dos listas. Cada lista totaliza una columna que tienen valores numéricos.

 

Es posible restar estas 2 sumatorias teniendo en cuenta que son de 2 listas diferentes?

adriancastano_1-1596242457100.png

 

Gracias por la ayuda

4 Replies

@adriancastano  claro que si es posible en la segunda list en tu opcion de suma seleccionas conseguir orbusca informacion ya en este sitio eliges la columna y la agregas a la formula.

Buen día @jnava_19 

 

De antemano muchas gracias por responder tan pronto.

 

Estuve analizando las dos respuestas pero no logro solucionar.

 

Lo explico de la siguiente manera: en una pagina que tengo en SharePoint estoy mostrando 2 listas. La primer lista describe un contrato por 4.000.000 y la segunda lista describe los pagos que se hacen al contrato, para este ejemplo se ha hecho un pago por valor de 1.000.000. Ahora bien, las vistas de las listas ya están totalizando el valor. Lo que requiero es que el usuario que llega a visitar esa página, pueda ver en un campo que no sé como insertar en modo diseño de SharePoint, que muestre la diferencia entre los totales de las 2 listas.

 

Las soluciones que me propones hacen sumatoria en las listas pero sigo sin poder mostrar a los visitantes de la página la diferencia entre estos 2 totales.

 

Muchas gracias.

@adriancastano I think this could be achieved with a PowerApps customised form, but I'd have to do some experiments.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User