Kuroshi Posted December 26, 2019 Report Share Posted December 26, 2019 Got a "ERROR IN FORMULA." message after clicking (two time) the DataPage number column header. (IsNull([@field:firstfield], 0)- IsNull([@field:secondfield], 0)- IsNull([@field:thirdfield], 0)- IsNull([@field:fourthfield], 0)) /(IsNull([@field:fifthfield], 0) Quote Link to comment Share on other sites More sharing options...
0 Barbie Posted December 26, 2019 Report Share Posted December 26, 2019 Hi @Batchini, It seems that some of your fifthfield contains 0 value. What I suggest is to use NULLIF instead of ISNULL. You formula should be like this:(IsNull([@field:firstfield], 0)- IsNull([@field:secondfield], 0)- IsNull([@field:thirdfield], 0)- IsNull([@field:fourthfield], 0)) /NULLIF([@field:fifthfield], 0) I hope this works. -Barbie Quote Link to comment Share on other sites More sharing options...
0 PotatoMato Posted January 15, 2022 Report Share Posted January 15, 2022 Hi, just to update this post. You may also check this how-to article regarding the error in formula: https://howto.caspio.com/troubleshooting/errors-and-messages/ Quote Link to comment Share on other sites More sharing options...
Question
Kuroshi
IsNull([@field:secondfield], 0)-
IsNull([@field:thirdfield], 0)-
IsNull([@field:fourthfield], 0))
/(IsNull([@field:fifthfield], 0)
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.