I am having a problem with a calculated result displaying when it shouldn't, obviously there is something wrong with my argument.

This is a relational database.

Three fields are involved.

"Estimated Cost" (number field with a dollar figure entered that is the estimated cost of a project)

"Total Jacket Cost" (a calculation field from the related database (Calculation Result is a Number))

"Approaching Estimate" (Calculation Field that should appear as the result of a calculation (Calculation Result is Text)

I have tried the following arguments:

Case( Total Jacket Cost > (Est. Cost * .85),

"Approaching Estimate" , IsEmpty(Est. Cost), "", "")

If(Est. Cost > Total Jacket Cost * .85 , "Approaching Estimate" , "" )

The problem is that this field is returning a result whenever any entry is in the field "Total Jacket Cost"

(I tried to insert a screen shot here for clarification but don't know how)

I have tried numerous combinations of these arguments. All I want to see is the return "Approaching Estimate" when "Total Jacket Cost" exceeds 85% of the "Estimated Cost".

What is amiss with these arguments?

If(Est. Cost > Total Jacket Cost * .85 , "Approaching Estimate" , "" )

All I want to see is the return "Approaching Estimate" when "Total Jacket Cost" exceeds 85% of the "Estimated Cost".

So the above calculation you should check the reverse condition:

if(Total Jacket Cost > (Est. Cost * .85),"Approaching Estimate","")

You can use: case(

isempty(Total Jacket Cost), "",

(Total Jacket Cost > (Est. Cost * .85)),"Approaching Estimate",

"")

I stopped fighting this problem, went to lunch, cleared my head, thought about something else. Got back, looked at the calculation and found my problem to be the order of the argument.

The resolved solution is:

Case( IsEmpty(Est. Cost),"" , Main to Action by Jacket::Total Jacket Cost > (Est. Cost * .85), "Approaching Estimate", "")

Thanks for your help, I'll keep your soultion in case my doesn't pass testing.

You found out exactly what I had thought and written above.

If( not IsEmpty(Est. Cost) and Main to Action by Jacket::Total Jacket Cost > Est. Cost * .85, "Approaching Estimate" )

should work also.