Round and % formulae

Gaurav Chauhan

Can you please check this formulae below. I need to round up the value to 2 digits and add %

=INDEX(COLLECT({Profit Margin}, {Program Name}, CONTAINS([Program Name]@row, @cell)), 1)

Currently the value output is 41.395

Expected results is 41.39%

Find more posts tagged with

Accepted answers

All comments

Mike TV

@Gaurav Chauhan

Does this work?

=ROUNDDOWN(INDEX(COLLECT({Profit Margin}, {Program Name}, CONTAINS([Program Name]@row, @cell)), 1),2)+"%"

Gaurav Chauhan

Hi, thank you for the help.. But adding ROUNDDOWN leads to INVALID

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.