Rule with division always returns zero. Any ideas?

This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

  • Rule with division always returns zero. Any ideas?

    Hello, I am creating a rule through Rule Editor but it does not work. It involves division or two Measures but it always returns zero. The rule is:

    ['UnitsAvg']=['Units']/['Assortment']

    In some cases ['Assortment'] has zero values.

    I tried this rule

    ['UnitsAvg'] = IF(['Assortment'] == 0, 0, ['Units'] * 1 / ['Assortment'] * 1)

    but even this does not return results.

    Help please?

    The post was edited 3 times, last by gm395 ().