Forum Discussion

michellepace's avatar
michellepace
Resolver III
6 years ago
Solved

Add Custom Column // use MOD( ) for values

Hi there.   If the value in AccNumber ends in 3 zeros, then the particular account is a "main account". Otherwise it is a "sub account". I'm trying to use the MOD( ) function as shown in the code b...
Need Help
  • Nathaniel_C's avatar
    Nathaniel_C
    6 years ago

    Hi michellepace ,

    Try Number.Mod ()

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
    Nathaniel

Nathaniel_C's avatar
Nathaniel_C
Community Champion
6 years ago

Hi michellepace ,

Try Number.Mod ()

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

  • Nathaniel_C's avatar
    Nathaniel_C
    Community Champion
    6 years ago

    Hi michellepace , just make sure AcctNumber is not text.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
    Nathaniel