Skip to Content
avatar image
Former Member

decimals

Hi All,

I have a formula like below and which is returning string type.

I am keeping my report in one application but there I am getting my numeric values as 1.00 which I dont want.I want without decimals.

Please help

if {Command.pValue} = 'Y'

then

(

if {Command.putawayCnt}= 0 and {Command.crossdockCnt} = 0 then

  ''

  else

  'Total Crossdock Cartons  :'   & '  ' &  sum({Command.crossdockCnt})

)

else ''

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 12, 2015 at 03:08 PM

    Hi,

    Try this:

    if {Command.pValue} = 'Y'

    then

    (

    if {Command.putawayCnt}= 0 and {Command.crossdockCnt} = 0 then

      ''

      else

      'Total Crossdock Cartons  :'   & '  ' &  cStr(sum({Command.crossdockCnt}), '#')

    )

    else ''

    Thanks,

    Raghavendra

    Add comment
    10|10000 characters needed characters exceeded