3 Replies Latest reply on Sep 14, 2018 6:40 AM by Ankit Bansal

# get right most integer from a integer with RIGHT or ???

i get an error, seems that RIGHT() only works with strings, i have an integer i need to test the last digit, how can i grab the last digit from integer like 20173

(i actually am testing if 3 so I can say its the 3rd quarter)

• ###### 1. Re: get right most integer from a integer with RIGHT or ???

Hi

it will return the right most integer - the function is called Mudolo and returns the "remainder after that would result from the division of the measure by the value thea follows the % sign

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

• ###### 2. Re: get right most integer from a integer with RIGHT or ???

Hi,

Here I have attached screen shot with solution. Please take a look.

RIGHT(STR([Postal Code]),2)

Here I have grabbed last 2 digit from postal code. Please use according to your use.

best

Suman

1 of 1 people found this helpful
• ###### 3. Re: get right most integer from a integer with RIGHT or ???

You can first convert to string using STR function and then use RIGHT function.

1 of 1 people found this helpful