topic Re: Sum numbers and distinct value in App Development

Sum numbers and distinct value

Ronald — Sat, 16 Nov 2024 21:16:07 GMT

Hola requiero su ayuda; tengo una tabla en QS con los siguientes valores; como puedo obtener el total de '60,82' ya que, las dos primeras fila se repiten en valor, pero el campo 'rep' es diferente. Puedo usar la función Distinct de alguna manera para que no me considere el campo 'rep'

Result KPI=60,82

Re: Sum numbers and distinct value

Wlad_Masi — Tue, 12 Mar 2019 14:28:09 GMT

Hi Ronal,

you can use sum(distinct field) as you can see in the image below:

In this case you are going to count distinct, but the "duplicate" values is still going to be showed, because they are not duplicated if you consider to entire line of data for example in your case the first and second line are not considered duplicated because you have rep 1 and 2.

To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.

Re: Sum numbers and distinct value

Ronald — Tue, 12 Mar 2019 15:29:07 GMT

Thanks for the quick replay; the information is duplicated for rep1 and rep; I must do the distinct for the fields, the table should be as follows, without the rep field:
1001 163 376402 M1 18,43

Re: Sum numbers and distinct value

Wlad_Masi — Tue, 12 Mar 2019 15:32:51 GMT

If you have "Rep" added to your table as a column you won't be able to show only one value. As I said you have different rep values for the first and second lines what makes them unique.

Re: Sum numbers and distinct value

Ronald — Tue, 12 Mar 2019 17:11:37 GMT

Then, I want to show in KPI the value $60,82, is possible with the Distinct function?

Re: Sum numbers and distinct value

Luis_Calvo — Tue, 12 Mar 2019 20:11:55 GMT

Intenta con esto

sum(aggr(max(valor),codigo,prod,art,clase))

Saludos

Re: Sum numbers and distinct value

Ronald — Thu, 21 Mar 2019 15:10:33 GMT

Hola, gracias, pero me sigue saliendo el mismo valor total 😞 y no $60.82

Re: Sum numbers and distinct value

Luis_Calvo — Thu, 21 Mar 2019 15:38:27 GMT

Hola Ronald,

Que raro, cargue tu tabla y si que me da el dato. Adjunto imagen.

Saludos

Re: Sum numbers and distinct value

Ronald — Thu, 21 Mar 2019 16:25:45 GMT

Vor a probar y te comento, gracias

Re: Sum numbers and distinct value

Ronald — Thu, 21 Mar 2019 21:45:40 GMT

Perfecto muchas gracias, me sirvió tú sugerencia

Re: Sum numbers and distinct value

Ronald — Fri, 22 Mar 2019 15:22:35 GMT

Tengo otra duda, si pongo algún filtro en la hoja no quiero que el resultado se vea alterado, por ejemplo: sum({Campo} aggr(max(valor),codigo,prod,art,clase))