topic error en suma in QlikView

error en suma

omarlq20 — Fri, 20 Nov 2020 18:02:30 GMT

Espero que me puedan ayudar, el problema que tengo es que hay un campo que le estoy poniendo una formula y esta sumando mal, lo que sucede que el yo estoy poniendo si tiene fecha, sumar, pero lo que esta haciendo es que apesar que no tenga fecha igual esta sumando en total, espero que me puedan ayudar adjunto el qlikview

Monto	Fecha	Total
100	15-02-2012	100
50		0
	Total	150

I hope I can help, the problem I have is that there is a field that I am putting a formula and is adding wrong, what happens that I'm getting if you have time, add, but what you are doing is that despite not this sum has the same date in all, I hope you can help me attach the qlikview

error en suma

Sun, 19 Feb 2012 07:29:36 GMT

Hi Omar, I'm unable to view this as I have the personal edition only on my home PC. Could you detail the expression that you are using for total? This could help me find the problem, thanks.

Erica

Re: error en suma

omarlq20 — Tue, 21 Feb 2012 15:56:03 GMT

Hi Erika, I'm doing the sum on the condition if

If(IsNull(Fecha),0,Monto)

but that sums it all

otherwise

CARGO

IF([WTS INV. AMOUNT] * 0.0025 < 100, 100, Sum([WTS INV. AMOUNT]*0.0025))

CARGO COMISION BCP

Sum(Aggr(IF([WTS INV. AMOUNT] * 0.0025 < 100, 100, Sum([WTS INV. AMOUNT])*0.0025),PO))