If then Formula

[Gizmo0917]

I have a formula that goes like this:

if {Tank_Log.Total Charges per Inometer}>12000 then 12000

I want to add to that formula that if it is less than 12000 then let the original amount show. What do I need to add to this??

Thanks!
Gizmo

 

[synapsevampire]

Try:

Ff {Tank_Log.Total Charges per Inometer}>12000 then
12000
else
{Tank_Log.Total Charges per Inometer}

-k

 

[Gizmo0917]

Thanks I was getting close! That works!