Avoid Postback on NaN fix

Question

I created a form in InfoPath, in which current Year information is compared in a calculated value to Previous Year. Each Year is in a different list, so to calculate the variance percentage I did something like this:

 translate(CurrentYearField1 * 100 / PreviousYearField1 - 100, "aINnfity", "00")

This calculation was causing a postback, showing a "Sending information to the server" message every time a field is modified. The "translate" and "aINnfity" are only to avoid the "NaN" or "Infinity" instead of the real information. If I remove them, leaving the calculated field like this:

CurrentYearF1 * 100 / PreviousYearF1 - 100

There is no postback, but I get "NaN" or "Infinity" if any of the fields is 0. Disabling postback in the "Browser Forms" options stops the postback from happening, but it doesn't update the calculated value when one of the fields is modified.

Is there anyway to avoid the postback and the "NaN" at the same time?

Regards!

Answer 1

Maybe try doing it with an action, something along the lines of:

    If CurrentYearField1 is not blank and PreviousYearField1 is not blank
    Set field value: Your calculated field equals expression: 
translate(CurrentYearField1 * 100 / PreviousYearField1 - 100, "aINnfity", "00")