InfoPath Dev

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!!

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

Added the form for inspection.

 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.