Calculating SUM pending on dropdown selection

Hey all,

I'm trying to calculate a sum pending two different drop down selections but having challenges with making it work. Any help would be greatly appreciated!

=IF(OR(Coverage@row = "Travel", Coverage@row = "Local", Coverage@row = "2 Locations"), (SUM([# of Shifts]@row * 12))), (OR(Coverage@row = "Planning Only"), (SUM([# of Shifts]@row * 6)))

Thanks!

Matt

Find more posts tagged with

Formulas

Accepted answers

All comments

Matt Fruitman

^ It works until I add the second layer of the "Planning only."

Genevieve P.

Hi @Matt Fruitman

You don't need the second OR since you only have one Coverage option for the second part of your formula. Instead you'll want to have another IF statement as your second statement.

You also don't need to say SUM if you're using the * function to multiply your values.

Try this:

=IF(OR(Coverage@row = "Travel", Coverage@row = "Local", Coverage@row = "2 Locations"), [# of Shifts]@row * 12, IF(Coverage@row = "Planning Only", [# of Shifts]@row * 6))

This will multiply [# of Shifts] in this row by 12 if Coverage is Travel, Local, or 2 Locations.

Otherwise, if Coverage is "Planning Only", it multiplies [# of Shifts] by 6.

Is this what you were looking to do?

Cheers!

Genevieve

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.