I have a field with the number of days, and the total fee. I wanted to create a formula field where I could add this logic below. Is this possible to compute?
One month or less (≤ 30 days) | 10% of the Fee |
2-3 Months (31-90 days) | 20% of the Fee |
4-6 Months (91-180 days) | 50% of the Fee |
7-8 Months (181-240 days) | 60% of Tof the Fee |
9-10 Months (241-300 days) | 75% of of the Fee |
Hi Viado! While I'm sure there's a more streamlined way to do this, I just made this out as a long nested IF(). In this example, I've assumed "50" as the fee value, although yoi could replace this with a field instead for variable fees. Hope this helps!
IF(
{Count Days} <= 30,
0.1*50,
IF(
AND(
{Count Days} <= 90,
{Count Days} >= 31
),
0.2*50,
IF(
AND(
{Count Days} <= 180,
{Count Days} >= 91
),
0.5*50,
IF(
AND(
{Count Days} <= 240,
{Count Days} >= 181
),
0.6*50,
IF(
AND(
{Count Days} <= 300,
{Count Days} >= 241
),
0.75*50,
IF(
{Count Days} >= 301,
1*50
)
)
)
)
)
)
Hi @Viado and @Josh_Colina
If they were nested, there would be no need for the >= line.
IF({Days} <= 30,
0.1*{Total Fee},
IF({Days} <= 90,
0.2*{Total Fee},
IF({Days} <= 180,
0.5*{Total Fee},
IF({Days} <= 240,
0.6*{Total Fee},
IF({Days} <= 300,
0.75*{Total Fee},
{Total Fee}
)
)
)
)
)It's better to have a simple formula!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.