Number Format

[upaliwije]

In my text box I have following experession

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

-

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

But my output  is not formatted and output is like given below.

69143848.666667

Pls advise me to get a output like   69,143,848

[Anonymous]

you must format not like num(A)-num(B) ,

but rather like

num(A-B)

[kaushiknsolanki]

Try this.

=(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')

Regards,

Kaushik Solanki

[upaliwije]

The issue is still thre with following message

Error in expression

=(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')

The comma 3), is highlighted in red

[upaliwije]

[Anonymous]

=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')

[kaushiknsolanki · Accepted solution]

Try this,

=

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')

Regards,

Kaushik Solanki