If expression in Text Object

[paulopereiraqv]

The result of this expression is equal to zero but whwn i do an IF expression in a Text Object  the result is different  than Zero. Can someone help me with this. Thanks.

Qtd1 = 10

Qtd2 = 10

Qtd1 - Qtd2 = 0

=If(num(Sum( {< PromoOpor = PromocoesWISE::PromoOpor, DateWise = PromocoesWISE::DateWise >} Qtd1) -
Sum( {< Promo = PromocoesSAP::Promo,Date = PromocoesSAP::Date >} Qtd2), '#,##0.00') = 0, 1, 0)

[marcus_sommer · Accepted solution]

Quite probably are the results of Qtd1 and Qtd2 not absolutely identically. Try it with the following change:

=If(round(Sum( {< ... >} Qtd1), 0.01) - round(Sum( {< ... >} Qtd2), 0.01) = 0, 1, 0)

- Marcus

[paulopereiraqv]

Thanks Marcus. You save my Day.