Net Transfers in Claims Information Processor

[Sherwin Ditlove]

Net Transfers is a calculated value on the Claims Information Processor screen. Has anyone tried to figure out a formula to accomplish that? Is it possible?

McKesson support is not an option.

I have tried with the following:
DECLARE
       ,:XAMTDUE NUMERIC (15,2)
       ,:XTOTADJ NUMERIC (15,2), :XTOTCSH NUMERIC(15,2)

SELECT
        (:XAMTDUE + (:XTOTADJ + (:XTOTCSH * -1))) * - 1 AS NETTRFR 

      
but it's not consistent with all accounts when using table FB_CLM_AUDIT_CARR.

These values :XAMTDUE, :XTOTADJ & :XTOTCSH are from a Sub-query accumulated from FB_CLM_AUDIT_CARR

I would appreciate any help.

Thank you

Sherwin Ditlove
sdit...@saint-lukes.org
Bus: (847) 410-7425

[Sherwin Ditlove]

This request can be discarded.

Thank you

Sherwin Ditlove