Skip to main content

Confused - Could be simple?

  • March 22, 2021
  • 1 reply
  • 0 views
S

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!

1 reply

M
Forum|alt.badge.img+12

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')

Justin_Barrett
1 person likes this
  • Justin_Barrett
    Justin_Barrett

Reply


Most helpful members this week

Terms & Conditions