Help

Confused - Could be simple?

Topic Labels: Formulas
497 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Shawn_Ryken
4 - Data Explorer
4 - Data Explorer

Hello,

New to AT community and hope to find help. This could be extremely simple but not sure how this field needs to be coded.

Column needing help = “Monthly Fee”

As shown in the fee section, is there a way to assign a value to each selected fee? For example, Exempt = $0, Forewarn =$5, Admin =$10? Therefore once any combination of those fees are selected it populates a total in the Monthly Fee section?
Assume the Monthly Fee section needs to be a formula but not sure which formula it needs to be or how to do it?

Thanks so much!AT Question

1 Reply 1
momentsgoneby80
7 - App Architect
7 - App Architect

Hi and welcome @Shawn_Ryken!
I would suggest making {Monthly Fee} a formula field and use a SWITCH()-formula in it.

SWITCH({Fees},
	'Exempt','$0',
	'Forewarn','$5',
	'Admin','$10'
)

If you’re going to use the output in another field I would recommend to leave out the dollar sign in your SWITCH()-formula.

You can find a realy handy formula field reference guide here for future use.

EDITED: Sorry, I was too fast to post / too fast reading, so I missed that it’s a multiple select field.
I’ll update with an answer in a bit.

Okay, this is maybe not all that elegant, but it does what you’re asking for.

IF(FIND('Exempt',{Fees}),'0')+IF(FIND('Forewarn',{Fees}),'5')+IF(FIND('Admin',{Fees}),'10')