Joined: 26 Mar 2013
Location: United States
Online Status: Offline
Posts: 4
Topic: If IsNull - Error A String is required here Posted: 05 Apr 2013 at 9:41am
I get A String is Required here with this formula - can anyone help me identify my problem??
//This formula checks to see if DRG expected reimbursement is empty, possibly indicating a Medicaid patient if IsNull ({HSP_ACCOUNT.DRG_EXPECTED_REIMB}) then "Medicaid"
//If the DRG expected reimbursement is provided, display the value stored in the DRG Expected Reimbursement field
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 05 Apr 2013 at 11:26am
I am assuming that {HSP_ACCOUNT.DRG_EXPECTED_REIMB} is not a string. The results from a if statement have to be the same data type. So the only solution is to convert {HSP_ACCOUNT.DRG_EXPECTED_REIMB} to a string (i.e., totext({HSP_ACCOUNT.DRG_EXPECTED_REIMB}) )
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
