Expression

[#1]

Hello,

I am having difficulty getting my expression to show the correct result.

=Sum({<[GLOBAL RESIDUAL LOSS REPORT RETURN TYPE]={'C','D'}>}[GLOBAL RESIDUAL LOSS REPORT JOURNAL DR])

-

Sum({<[GLOBAL RESIDUAL LOSS REPORT RETURN TYPE]={'C','D'}>}[GLOBAL RESIDUAL LOSS REPORT JOURNAL CR])

-

Sum([Collections Recovery Chargeback Collection Recovery])

/

Sum([Risk Credit Rejects Total Sales])

Result for the first part of that expression is $2,127,826.04.

Result for the second part of that expression is $10,880,952,862.78.

The end result should be 0.019%.

I have verified through calculation. Where I am trying to put this expression is in a Gauge Chart configuration. I am not coming up with a result of that 0.019%.

Any help would be appreciated.

Thanks

Manny

[sunny_talwar]

What are you stating as the first and second parts here??? May be you need to add parenthesis around the numerator:

=(Sum({<[GLOBAL RESIDUAL LOSS REPORT RETURN TYPE]={'C','D'}>}[GLOBAL RESIDUAL LOSS REPORT JOURNAL DR])

-

Sum({<[GLOBAL RESIDUAL LOSS REPORT RETURN TYPE]={'C','D'}>}[GLOBAL RESIDUAL LOSS REPORT JOURNAL CR])

-

Sum([Collections Recovery Chargeback Collection Recovery]))

/

Sum([Risk Credit Rejects Total Sales])

Because in your current state only this -> Sum([Collections Recovery Chargeback Collection Recovery]) is getting divided by the denominator.

HTH

Best,

Sunny

[#3]

Hi Sunny,

By first part I mean:

=Sum({<[GLOBAL RESIDUAL LOSS REPORT RETURN TYPE]={'C','D'}>}[GLOBAL RESIDUAL LOSS REPORT JOURNAL DR])

-

Sum({<[GLOBAL RESIDUAL LOSS REPORT RETURN TYPE]={'C','D'}>}[GLOBAL RESIDUAL LOSS REPORT JOURNAL CR])

-

Sum([Collections Recovery Chargeback Collection Recovery])

Second part is:

Sum([Risk Credit Rejects Total Sales])

[sunny_talwar]

Did you try putting the parenthesis around the numerator as I suggested?

=(Sum({<[GLOBAL RESIDUAL LOSS REPORT RETURN TYPE]={'C','D'}>}[GLOBAL RESIDUAL LOSS REPORT JOURNAL DR])

-

Sum({<[GLOBAL RESIDUAL LOSS REPORT RETURN TYPE]={'C','D'}>}[GLOBAL RESIDUAL LOSS REPORT JOURNAL CR])

-

Sum([Collections Recovery Chargeback Collection Recovery]))

/

Sum([Risk Credit Rejects Total Sales])