External data help

[Susan]

I have a table which uses external data by matching account numbers. Below the table are totals which are taken from the mailing data brought in through FusionPro (not in my table rule). I was wondering if there is a rule that would subtract an amount in a external data field from an amount in the mailing data. I've attached a sample of what I mean.

FP Help.zip

[Dan Korn]

This should work:

var InvoiceTotal = StringToNumber(Field("INVOICE TOTAL").replace(/[\$,]/g, ''));
var WPP = StringToNumber(Rule("WPP Field"));
return FormatNumber("$#,###.00", InvoiceTotal - WPP);

[Susan]

Thanks Dan, worked great.