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?