Hi, I have a calculated field that had an error, who'd figure I'de make a mistake.
Anyway I first tried correcting the problem then discovered it wouldn't update. It showed the results in the edit correctly, but when I clicked done, it didn't update in the app.
So I then thought fine, I'll create a new calculated field and rename the old field. (The result if this field is used in another calculation) I then delted the old field and ran cleanup. Now the old field still shows when I click on a record, but doesn't show when I click modify.
Basically the formula is like this.
CalcF1 = InputF1 / InputF2
Calcf2 = If Calcf1 > 10 then 5 else if Calcf1 > 5 then 1
Calcf3 = Calcf2 + Calcf4 + Calcf5
So the total in Calcf3 is also not updating.
I hope I this is somewhat clear.
We use this to calculate awards for our chapters.
Please sign in to leave a comment.