Share
Report
75Hello,
We have a service where people build up a balance daily and pay off the balance when it reaches an amount they set. Depending on what level of service they have their monthly rate could be $99, $199, or $299. For each contact, we want to to divide their monthly rate by the days in the current month, so at any point if they wanted to stop or pay down their balance, we can easily see what that is. It will also help our accounting people keeping track of things.
Does anyone have an easy way that comes to mind to make this calculation? I am guessing we will need to convert the current value to an integer, which seems simple enough. What I am struggling with is how to get the days in the current month, and then convert that to an integer also. Will I need to use compose to calculate the numerator and denominator separately, and then setting up the divide function w/ the compose outputs? Or would it be doable to make the entire calculation in one expression? Any thoughts or guidance will be greatly appreciated.
All responses (
Answers (
