calculate subtotal skiping strings

rafael5958 — Fri, 18 Aug 2023 17:50:03 GMT

We have a dynamic table with this expresion:

if(previsao_entrega='-',null(), if(Round(previsao_entrega-Date(now()), 1)>0,Round(previsao_entrega-Date(now()), 1),'revisao'))

with subtotal itt shows:

How can I show sum as 17 and 33, and not the string revisao ? Calculate only numbers.

thank you

Re: calculate subtotal skiping strings

pedrohenriqueperna — Fri, 18 Aug 2023 20:08:16 GMT

Should "revisao" be considered a 0 or Null() when adding up?

If so, you could use Dual(). This function takes 2 parameters, the first is a text string that you want to display, and the second is a numeric value or expression that results in a numeric value (which can be sum and sorted as a number)

Try this:

If(previsao_entrega = '-', Null(), If(Round(previsao_entrega - Date(Now()), 1) > 0, Round(previsao_entrega - Date(Now()), 1), Dual('revisao', 0)))

////

O campo "revisao" deveria ser lido como 0 ou nulo?

Se sim, você poderia tentar usar a função Dual() que recebe um valor de texto para ser exibido e um valor númerico para ser interpretado.

Testa isso:

If(previsao_entrega = '-', Null(), If(Round(previsao_entrega - Date(Now()), 1) > 0, Round(previsao_entrega - Date(Now()), 1), Dual('revisao', 0)))

topic calculate subtotal skiping strings in QlikView

calculate subtotal skiping strings

Re: calculate subtotal skiping strings