cancel
Showing results for 
Search instead for 
Did you mean: 

Convert Sum value to text (Part II)

former_member406941
Participant
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

abhilash_kumar
Active Contributor
0 Kudos

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

former_member406941
Participant
0 Kudos

Thanks, Abhilash.  That formula works but it's not yielding the correct result.  The formula, without the if then else statement, that yields the correct result is:

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

abhilash_kumar
Active Contributor
0 Kudos

How about:

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

"N/A"

else

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


-Abhilash

former_member406941
Participant
0 Kudos

Bingo.  Thank you!!!!!

Answers (0)