Expression Not Working

[Moxioron]

Hello.

I am stumped as to why an expression I put together isn't working.

Basically I am taking this expression:
=(Sum([SumOfCredit Line Amount])-Sum(IIf([Status Description]="Charged-Off",[SumOfCredit Line Amount])))-(Sum([SumOfAccount Balance Total Amount])-Sum(IIf([Status Description]="Charged-Off",[SumOfAccount Balance Total Amount])))

and Dividing it by this expression:

=Sum([SumOfCredit Line Amount])-Sum(IIf([Status Description]="Charged-Off",[SumOfCredit Line Amount]))

The two expressions by themselves work correct ($314,046,974 for the first one and $356,687,544 for the second one).

By using the following expression the expected result is 88%. However, I am getting 3429544208849%.

=(Sum([SumOfCredit Line Amount])-Sum(IIf([Status Description]="Charged-Off",[SumOfCredit Line Amount])))-(Sum([SumOfAccount Balance Total Amount])-Sum(IIf([Status Description]="Charged-Off",[SumOfAccount Balance Total Amount])))/Sum([SumOfCredit Line Amount])-Sum(IIf([Status Description]="Charged-Off",[SumOfCredit Line Amount]))

Where am I going astray? thank you.

 

[pr2-eugin]

Looks like you are missing some parentheses. Try.

=((Sum([SumOfCredit Line Amount])-Sum(IIf([Status Description]="Charged-Off",[SumOfCredit Line Amount])))-(Sum([SumOfAccount Balance Total Amount])-Sum(IIf([Status Description]="Charged-Off",[SumOfAccount Balance Total Amount]))))/(Sum([SumOfCredit Line Amount])-Sum(IIf([Status Description]="Charged-Off",[SumOfCredit Line Amount])))

 

[Moxioron]

Thank you. That was it.

 

[pr2-eugin]

You're welcome !