Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to use this code in a text box:
=Sum( {$<YEAR = {$(#=Max(YEAR))}, [Week No]= {$(#=Max([Week No]))}, DT = {'Date'}, CT -= {ITC}, DCCF = {YES}>} $(vMargin))
and its showing me this number: 906086.66789
When I want it to show as: $906,086.66
When I do this:
=Sum( {$<YEAR = {$(#=Max(YEAR))}, [Week No]= {$(#=Max([Week No]))}, DT = {'Date'}, CT -= {ITC}, DCCF = {YES}>} AMOUNT)
Its show me the number as $3,000,000.86 (perfectly)
Thanks,
J
Try
= Money(
Sum( {$<YEAR = {$(#=Max(YEAR))}, [Week No]= {$(#=Max([Week No]))}, DT = {'Date'}, CT -= {ITC}, DCCF = {YES}>} $(vMargin))
)
and set the money format in the script (at the very beginning, the format codes are defined).
Maybe this?
num(Sum( {$<YEAR = {$(#=Max(YEAR))}, [Week No]= {$(#=Max([Week No]))}, DT = {'Date'}, CT -= {ITC}, DCCF = {YES}>} $(vMargin))) ,'$#,##0;($#,##0.00)')
Try this in any text object
=NUM( Sum( {$<YEAR = {$(#=Max(YEAR))}, [Week No]= {$(#=Max([Week No]))}, DT = {'Date'}, CT -= {ITC}, DCCF = {YES}>} $(vMargin)),'$#,##0.00', '.',',')