calculate subtotal skiping strings

[rafael5958]

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

[therealdees · Accepted solution]

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)))