Newbie Questions

Re: Displaying % symbol in calculated formula

Dan27 — Fri, 05 Sep 2014 19:09:35 GMT

Thanks for your help. I've managed to get rid of the NaN. How can I get rid of the NaN and display a % symbol within the same formula?

Thanks

Re: Displaying % symbol in calculated formula

Heidi — Fri, 05 Sep 2014 15:51:33 GMT

concat(sum(@NewAmount) - @PreviousAmount div NewAmount, "%") in the calculated field. That should work to get that percent sign. Replace the NewAmount etc. with the actual field name.

For your NaN problem, you can check out this link.

Hope that helps!

Heidi

Re: Displaying % symbol in calculated formula

Dan27 — Fri, 05 Sep 2014 14:38:50 GMT

It's just trying to calculate a percentage difference between 2 fields so

New Amount - Previous Amount / New Amount

NaN appearing in the calculated field when new or previous are empty. I'd like it to be blank.

Re: Displaying % symbol in calculated formula

Heidi — Fri, 05 Sep 2014 14:04:27 GMT

Hi Dan,

Could you show me the formula that you're using in your calculated field, and is the NaN appearing in your calculated field, or in another area of your form?

Heidi

Displaying % symbol in calculated formula

Dan27 — Fri, 05 Sep 2014 12:01:23 GMT

Hello all

I'm brand new to InfoPath asnd have just started using it. One of the first tings I am having difficulty with is show a % in a calculated field. I've gone in to format in text box properties and tried a few other things but it still won't show as a %

Also is there an easy wat I can stop NaN appearing? I've seen IF statements don't really work like excel.

Thanks for your help

Dan