Skip to Content

Convert Sum value to text (Part II)

This is a very similar inquiry to this:

Here is my current formula:

if Sum({@Counter2013},{@InsuranceOrGroupName}) = 0 then "N/A" else

totext (Sum ({@Counter2014},{@InsuranceOrGroupName}) - Sum({@Counter2013},{@InsuranceOrGroupName})) % Sum({@Counter2013},{@InsuranceOrGroupName})

The error message I'm receiving is 'A number, or currency amount is required here' and it has this part of the formula highlighted:  totext (Sum ({@Counter2014},{@InsuranceOrGroupName}) - Sum({@Counter2013},{@InsuranceOrGroupName}))

Thank you!!

Rich

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 02, 2015 at 03:48 PM

    Hi Rich,

    Change the code to:

    if Sum({@Counter2013},{@InsuranceOrGroupName}) = 0 then

    "N/A"

    else

    totext (Sum ({@Counter2014},{@InsuranceOrGroupName}) - Sum({@Counter2013},{@InsuranceOrGroupName}) % Sum({@Counter2013},{@InsuranceOrGroupName}))

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded