Error in Text Box Calculation

[upaliwije]

I have the following chart in my QV Doc

In the above Text Box  (last one  28%)I want to calculate figure  1713182/4441686=38% But I get the answer as 28%

My expression is as follows

=NUM(((sum({<MO_NM={'MOTOR'},MONTH={'MAR'}>}(rangesum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))))

-

(sum({<MO_NM={'MOTOR'}>}(rangesum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE)))/3))

/ fabs(sum({<MO_NM={'MOTOR'},MONTH={'MAR'}>}(rangesum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE)))),'#,##0 %')

Pls advise What Mistake I have done and corret me

[Anil_Babu_Samineni]

Are you sure, You are using same which existing for 2 values

Would you able to share me sample applicaiton

[prieper]

Think that you have three values involved. A-B/C?

Suggest to

a) take out the formatting (this might be done as last step)

b) copy the formulas from each box but add parethesis for each expression and calculate A/B

Peter

[upaliwije]

Can you pls write the suggested expression

[prieper]

there are three parts in your view, am not sure, whether the brackets are correct.

Am neither sure, whether the combination of SUM(....RANGESUM(....)) works.

[vinieme12]

Can i suggest you simply copy paste the expressions you used in Textbox 1 and Textbox 2 directly as below

Textbox3 =  Texbox2 / Textbox1 ??

[upaliwije]

This is the sample data pls advise.

[Anil_Babu_Samineni · Accepted solution]

Check this, It's working for me

=Num((NUM((sum({<MO_NM={'MOTOR'},MONTH={'MAR'}>}(rangesum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE)))) - (sum({<MO_NM={'MOTOR'}>}(rangesum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE)))/3),'#,##0')) /

(NUM(sum({<MO_NM={'MOTOR'}>}(rangesum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE)))/3,'#,##0.')),'#,#0%')