function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Leyadk DevelLeyadk Devel 

Formula Help Requested

Hi guys,

 

I need to write a couple of formulas. I have two currency fields which I would like to make the value for into formulas:

 

1. Total Value of Savings Suggested

2. Total Value of Savings Implemented

 

I have 5 currency fields:

 

Value of Saving Initiative 1

Value of Saving Initiative 2

Value of Saving Initiative 3

Value of Saving Initiative 4

Value of Saving Initiative 5

 

Each has a corresponding checkbox - initiative implemented? If ticked, the saving has been implemented and if not it is suggested.

 

Thus I need to make my formulas dependent upon each of the checkboxes.

 

Please could anyone help with the writing of these formulas?

 

Many thanks,

Dave

STest123STest123

i think this is not possible.
Vz123Vz123

You could give a below try for the formula, though it will be length one:

 

FieldCheckbox

---------------------------------------

f1c1

f2c2

f3c3

Savings Implemented= IF( AND(c1=true,c2=true,c3=true), f1+f2+f3,

if(AND(c2=true,c3=true), f2+f3,

if(AND(c1=true,c3=true), f1+f3,

if(AND(c2=true,c3=true), f2+f3,

if(c2=true, f2,

if(c3=true,f3,

if(c1=true,f1,0))))))

and the other way check for  Savings Suggested  = if C1 = false, f2...

 

Thanks