Crystal Report formula error *

[arunsapbone]

Dear Experts,

I am getting the error in my crystal report formula, mentioned in my formula below.

I have to exclude the and zero from my crystal result.

Formula : numbervar x := {@TotalInvoiceAmount}; numbervar ipart; numberVar decpart; ipart := int(x); decpart := x - ipart; Propercase(Replace(towords(ipart)," and xx / 100",""))& " only" & if decpart = 0 then "" else " and "& Propercase(Replace(towords(decpart)," and xx / 100","")) &" only ";

Result: Ten Thousand Five Hundred One and Zero And 69 / 100 only

[former_member759204]

Try this:

numbervar x := {OEINVH.INVNETWTX};

numbervar ipart:= int(x);

numberVar decpart:= x - ipart;

If decpart <> 0 then Propercase(towords({OEINVH.INVNETWTX})) + " only" else Propercase(towords({OEINVH.INVNETWTX},0)) + " only"

[arunsapbone · Accepted solution]

Thanks, Jody

It's working fine.

[arunsapbone · Accepted solution]

numbervar x := {OEINVH.INVNETWTX};

numbervar ipart:= int(x);

numberVar decpart:= x - ipart;

If decpart <> 0 then Propercase(towords({OEINVH.INVNETWTX})) + " only" else Propercase(towords({OEINVH.INVNETWTX},0)) + " only"

[DellSC]

You can't use an If statement in the middle of building a string. I suggest creating a new string variable that will handle the "if" part of your logic. It will look something like this:

 numbervar x := {@TotalInvoiceAmount}; 
 numbervar ipart; 
 numberVar decpart; 
 stringvar endwords = " only";
 ipart := int(x); 
 decpart := x - ipart;
 if decpart <> 0 then and := " and " & Propercase(Replace(towords(decpart)," and xx / 100","")) & 
	 " only ";
 Propercase(Replace(towords(ipart)," and xx / 100",""))& endwords;

-Dell