Starting November 20, the site will be set to read-only.
On December 4, 2023,
Apex Code Development (90768)
General Development (55146)
Visualforce Development (37251)
Lightning (18265)
APIs and Integration (17146)
Trailhead (11680)
Formulas & Validation Rules Discussion (11337)
Other Salesforce Applications (8116)
Jobs Board (6655)
Force.com Sites & Site.com (4842)
Mobile (2694)
You need to sign in to do that
Don't have an account?
kaulsaksoft Hi
how to do "FOR" loop kind of functions in Formula Fields?
I need to execute the For
Sum from Y= 1 to Y=80 of { (1+400/100)**RATE}
Has anyone done the same in Salesforce without Apex Code
You can not use LOOPS in formulas. You could use s-controls, though.
To calculate the sum of all integers between 1 and n you can use the mathemetical formula: n(n+1)/2.
If this is your theorethical FOR LOOP:
Y = 80
result =0
FOR (rate = 1 to Y) {
result = result + (1+400/100)*rate)
}
(1+400/100) = 5, btw.
Then the formula
(Y(Y+1)/2)*5 will give you your result.
Is that what you were looking for?