I have got a field "Copy Cost" which has the following calculation.

If(PatternCount(Payment Info; "Make Good"); 0; If(GetAsNumber(Count of words in text field) <= 20; 19; Count of words in text field * .95))

I now need to incorporate the following calculation into the first one.

If(PatternCount(AD PRODUCTION; "Text Only Ad"); If(GetAsNumber(Count of words in text field) <= 20; 50; (Count of words in text field - 20) * .95 + 50))

Thanks in advance for any help.

Here is a sample file with the relevant fields.

I have changed the field name "Copy Cost" to

"Copy Cost Picture Ad with Text"

SampleDB1.fp7.zip

Let( C = WordCount(Ad Copy & " " & Name of individuals in Ads); Case( Payment Info = "Make Good"; 0; If( AD PRODUCTION = "Text Only Ad"; 50; 19 ) + .95 * (C - 20) * (C > 20) ) )

Thanks Queue