Hi there,
We have a field that says what the annual increase is. We have a flow that clones that contract a year later and in the description does a calculation to say what the % increase was, and what it was increased to. However, it is rounding down to 0. Normally the increase is around 4% or 5%. So the description will say "Increased 0% to 600/month" when it should be 4%. Was hoping to get help with this.
IF(
{!$Record.Cloned_From__r.Increase_Percentage__c > 0},
TEXT(TODAY()) & ": Increased " & TEXT({!$Record.Increase_Percentage__c}) & "% to $" & TEXT(ROUND({!$Record.Cloned_From__r.MRR__c} * (1+{!$Record.Cloned_From__r.Increase_Percentage__c}/100),0) ) & "/month.",
TEXT(TODAY()) & ": No Increase. Keep previous price."
)
@Monica Raimondi
try this one:
IF(
{!$Record.Cloned_From__r.Increase_Percentage__c} > 0,
TEXT(TODAY()) &
": Increased " &
TEXT(ROUND({!$Record.Cloned_From__r.Increase_Percentage__c}, 2)) &
"% to $" &
TEXT(
ROUND(
{!$Record.Cloned_From__r.MRR__c} *
(1 + {!$Record.Cloned_From__r.Increase_Percentage__c} / 100),
0
)
) & "/month.",
TEXT(TODAY()) & ": No Increase. Keep previous price."
)
({!$Record.Cloned_From__r.MRR__c} * (1 + {!$Record.Cloned_From__r.Increase_Percentage__c} / 100)) is rounded to 0 decimal places, ensuring that you get a whole number for the monthly rate. This should transform your example from $427.44 to $427 as you desire
