Joined: 25 Aug 2009
Location: United States
Online Status: Offline
Posts: 166
Topic: Error:Boolean required in Formula Posted: 28 Sep 2009 at 10:25am
Hello Folks,
I am trying to create a new formula which shoudnt have the negatives and also trying to get rid of a special field called gross_rec_nc, but eventually am getting this Boolean Error. Am providing the Error formula below. Can anyone please throw some light on this.
if {rep41_tbl_detail.gross_recovery} < 0 then 0 else {rep41_tbl_detail.gross_recovery} and({rep41_tbl_detail.gross_recovery} = {rep41_tbl_detail.gross_recovery} - {rep41_tbl_detail.gross_rec_nc})
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Posted: 28 Sep 2009 at 1:50pm
change the 0 to a false...just a guess, but what Crystal is telling you is that both 'parts' of an if have to return the same type of answer. It doesn't like:
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
