Tweet
Meanwhile I found the solution. Obviously you cannot put one substraction after another so the formula has to be in my case: open = total - (first + second);
Hello,
I read the instructions for calculated fields an I want to make simple calculations, which I did not succeed so far. I have a field, that should have a calculated value from three other values. The first is a total fee, for which I enter a first partial payment and later a second, final payment. The calculated field, which is read only, should show the possible missing amount.
As a normal calculation it looks like this:
Total fee: 250,00 €
first rate: 50,00 € (substract from total)
second rate: 200,00 € (subtract also from total)
results in open to pay : 0,00 € (in this case, because I subtracted first and second rate from total)
My formula is simply this way: open = total - first - second;
but it does not work, nothing will be subtracted. As field format I tried Currency and Float. What did I wrong? To make these calculations and equations, is it possible only with float or also with currency?
Hello,
I read the instructions for calculated fields an I want to make simple calculations, which I did not succeed so far. I have a field, that should have a calculated value from three other values. The first is a total fee, for which I enter a first partial payment and later a second, final payment. The calculated field, which is read only, should show the possible missing amount.
As a normal calculation it looks like this:
Total fee: 250,00 €
first rate: 50,00 € (substract from total)
second rate: 200,00 € (subtract also from total)
results in open to pay : 0,00 € (in this case, because I subtracted first and second rate from total)
My formula is simply this way: open = total - first - second;
but it does not work, nothing will be subtracted. As field format I tried Currency and Float. What did I wrong? To make these calculations and equations, is it possible only with float or also with currency?
Comment