If function

Hello, may I request assistance troubleshooting a formula? I have the formula below to identify if the reconciliation is out of balance. In January, the Available Resources and Fiscal Report Ending Balance match, yet the Status display Out of Balance. Is it because it's a negative number?

=IF([Available Resources]@row = [Fiscal Report Ending Balance]@row, "Balance", IF([Available Resources]@row <> [Fiscal Report Ending Balance]@row, "Out of Balance"))

Find more posts tagged with

Formulas

Accepted answers

Leibel S

@nskoulphong

Is it possible they are off by decimals?

You can correct this in the formula by adding the round function:

=IF(ROUND([Available Resources]@row, 2) = ROUND([Fiscal Report Ending Balance]@row, 2), "Balance", IF(ROUND([Available Resources]@row, 2) <> ROUND([Fiscal Report Ending Balance]@row, 2), "Out of Balance"))

All comments

Leibel S

@nskoulphong

Is it possible they are off by decimals?

You can correct this in the formula by adding the round function:

Nancy Skoulphong

@Leibel S thank you for your reply. Perfect!

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.