AnsweredAssumed Answered

Calculation field returning repeating value ie: 76007600760076007600 instead of just 7600

Question asked by lbl159 on Aug 24, 2015
Latest reply on Aug 24, 2015 by taylorsharpe

I have an If formula where the 'value if false' is a field that is a calculation (S4_Investor_Entities 1::S4_FMV).  Instead of returning just the correct number, it returns it repeating over and over again. Or sometimes it won't be exactly repeating and will look like: 17751057510575105751057510575106596.16 or 19612.519612.519612.519612.519612.519612.519612.5

 

As a test I added the field (S4_Investor_Entities 1::S4_FMV) to the layout on its own. That returned the correct values without any repetition. It is only when this field is being referred to as the 'value if false' in my If formula.

 

Any idea why this may be occurring?

Outcomes