Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Convert Sum value to text (Part II)

This is a very similar inquiry to this:

Convert Sum value to text

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

replied

How about:

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

"N/A"

else

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


-Abhilash

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question