on 01-02-2015 3:42 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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})
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.