You’re offline. This is a read only version of the page.

Microsoft Dynamics GP (Archived)

Management Reporter IF statement in CALC Column

(0) Share

Report

Posted on by Community Member

We want to force the result to be 100% or (100%) if either of these conditions exist:

IF Column B is BLANK THEN 1 OR IF Column C is BLANK THEN -1 ELSE Column D/Column C

I've tried many IF statements but they all error out and can't be saved.

Here is the latest example of the IF statement I'm using: IF B=0 THEN 1 OR IF C=0 THEN -1 ELSE D/C

With this formula I get an error that "The term "ELSE" is expected within the expression. Please add this term to the expression"

What is the correct Syntax for this formula?

Thanks.

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Helpful resources

Last 30 days Overall leaderboard

Dynamics 365 release plans