In this blog we will learn how to display the remainder of a number divided by another number from numeric column in Helical Insight.
- If we want to display the remainder of a number divided by another number .Click on Travel Cost column.
- Click on more, user will get two options i.e., Quick and Advanced
- Click on “Advanced” in this you will see a function called “mod”. Double click on that function and then drag the Travel cost column and give the value as 10 in divisor tab in the selected mod function box at the bottom. Click on Save button.
- Click on “Generate” report. You will see the desired output as below.
Note: These functions are specific to the database and may / may not appear based on the kind of database that you are connecting to. Please refer to below blog to add more database functions for your specific use case.
Adding Database Functions