Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Hola Ronald,
Que raro, cargue tu tabla y si que me da el dato. Adjunto imagen.
Saludos
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.
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.
Hola Ronald,
Que raro, cargue tu tabla y si que me da el dato. Adjunto imagen.
Saludos
Perfecto muchas gracias, me sirvió tú sugerencia