Newbie Questions

Re: Newbie function questions

Hilary Stoupa — Tue, 23 Feb 2016 16:04:50 GMT

I think this will do what you need for the percentage: (Kredittotal - Debettotal) / ((1 - (Kredittotal < 0) * 2) * Kredittotal)

You'll want to hide the field on the form if it contains "NaN" or "Infinity" - and you may want to set the data type to text to prevent validation errors. There is probably a fancy way to keep the formula from returning errors when Kredittotal is 0, but I am not very math-y. I'm not sure how to get a progress bar from dates.

Re: Newbie function questions

lartsa93 — Tue, 23 Feb 2016 13:08:30 GMT

Added the form for inspection.

Re: Newbie function questions

Hilary Stoupa — Mon, 22 Feb 2016 15:39:19 GMT

Do you mind attaching a copy of your form in a reply, under the Options tab, showing your current attempt?

Newbie function questions

lartsa93 — Tue, 16 Feb 2016 09:22:24 GMT

Hi! so i'm trying to calculate percentage between credit and debit. I managed to calculate it in excel (=(H26-G26)/ABS(H26)) but in infopath im completely lost. I tried some thing like this (Kredittotal - Debettotal) / (1 - (Kredittotal > 0) * 2) * Kredittotal. Also i'm having problems doing "progress bar". I'm trying to do a field which shows status as percent (in excel i did it like =(B8-TODAY())/(B8-B7)). B8 and b7 are dates. thanks!!