Try dropping the - sign in your formula IF({Doc Type}="C", -{True Amount}*{% Comm}/100, {True Amount}*{% Comm}/100).

But you should be able to use calculated column with the formula {True Amount}*{% Comm}/100).

David


Edited by doswalt (02/14/08 06:25 PM)