Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
you must format not like num(A)-num(B) ,
but rather like
num(A-B)
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
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
=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')
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