Formula: Modulo

This article will explain provide details and examples of this formula syntax usage

Background

Though we do not have the 'Modulo' operation available in the formula syntax it can be implemented using the 'FLOOR' formula. This article will show you how to achieve the following: 

X mod Y

Formula Syntax

X - ( Y * FLOOR ( ( X / Y ) ) )

  • X
    • Replace both instances of X with the same value
  • Y
    • Replace both instances of Y with the same value

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.