Division and Multiplication....

[leocattqv]

Hello,

I have 2 sums of Calculations that I am trying to Divide..and multiply

=Sum({<NCMR.Division={'TJM', 'VST'}>} [NCMR.Rej Qty]) /  (Sum({<NCMR.Division={'TJM', 'VST'}>})) [No_Approved Parts) *1000000

there is something in the syntax that is tripping me up.

Any suggestions?

thanks,

Leo Catt

[swuehl]

=Sum({<NCMR.Division={'TJM', 'VST'}>} [NCMR.Rej Qty]) /

Sum({<NCMR.Division={'TJM', 'VST'}>} [No_Approved Parts]) *1000000

[hic]

A mismatch of brackets in [No_Approved Parts)

HIC

[Anonymous]

=Sum({<NCMR.Division={'TJM', 'VST'}>} [NCMR.Rej Qty]) /  (Sum({<NCMR.Division={'TJM', 'VST'}>})) [No_Approved Parts) *1000000

remove the the second closing parenthesis in the denominator before [No_Approved Parts...also closing parentehsis for the field in the denominator is missing too. try this:

=(Sum({<NCMR.Division={'TJM', 'VST'}>} [NCMR.Rej Qty]) /  Sum({<NCMR.Division={'TJM', 'VST'}>} [No_Approved Parts]) )*1000000

i'm assuming you want the result from division to be multiplied with 1000000.