Applying Indian Number Formatting to Reward Letters

Some countries use different number formatting standards. For example, India formats numbers as xx,xx,xxx instead of the more common xxx,xxx,xxx style. If you want your reward letters to reflect Indian number formatting for INR amounts, follow these steps:

1. Open your letter template.

2. Go to the cycle's Settings page → Reward Letter Templates tab.

3. Copy the placeholder for the currency/decimal field you want to format.

4. In your template, paste the placeholder and replace the function:

   1. Change number_format(0) to india_number_format(0) for INR amounts.

   2. For non-INR amounts, continue using the standard number_format(0) function.

   3. Adjust the number inside the parentheses to set decimal places:

      • (0) → no decimal places

      • (2) → two decimal places

      • (3) → three decimal places, and so on

5. Upload the updated template in Settings.

6. Generate / regenerate the letters that are using the updated placeholders.

7. Download and test the letters to confirm the formatting displays correctly.

📌 Important Note

Indian number formatting will only reflect in the reward letters when you use the correct placeholder and function. It will not apply to the comp cycle workbook itself.

📌 Tips

• Use correct placeholders: Double-check that you’re editing the right field for INR amounts.

• Test before rollout: Always download a sample letter to verify formatting before allowing non-admins access to letters or sending to employees.

• Maintain consistency: Apply the same formatting across all templates to avoid confusion.