You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

MISSING values IN FRC

Accepted answer
29
Views
3
Comments

Summary:

MISSING values ​​do not work well in FRC reports.

For example, I have a column that has to add two columns, however one of them has a value of MISSING and when I transform it into Conditional Format to 0 for the formula to work, it doesn't work either.

Is there a way to make the MISSING values ​​treated as 0 (zero) so that they work well in the formulas?

Content (required):

I have created a report that shows all the accounts with the Initial Balance, Debit Value, Credit Value and Final Balance

The problem is that there are accounts with a balance of 0 (17100000) FOR  one period, so the Credit works correctly because there is a formula in the Credit Value (IfThen([A]<0,[F],[G])

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!