Forum Discussion
Storing Percentags
Whats the best pracctices for storing percentages against a user's profile.
Eg. I have a use case where I want to store the interest rate applied to a customer's loan on their profile.
Is it best practice to store it as a decimal eg. 0.05 or as a percentage 5.0%?
Hello dMoney
There isn't a one-size-fits-all best practice here—it depends on how you plan to use the data for segmentation or personalization.
Personally, I would avoid storing the "%" symbol as part of the value. I would use the attribute "interestRate" and store the value as 5.0. This way, I can avoid performing extra calculations when personalizing content or creating segments.
Adding to the comments above, it comes down to this:
Do you need it as an iteger or a string? Storing as an integer will let you use filters like "More than" and "Less than". It also lets you use math in liquid. As a string, you would be able to just display the content and segmentation would be more challenging, you'd need to use regex.
Integer: 0.005
String: 0.5%Could depend, how do you want to use it? I.E. Personalization (insert into message), Use for targeting such as over/under a specific rate?
