Hello @nascas
Thank you very much for the review.
Best regards.
Thread Starter
Rico
(@nascas)
Hi, You’re welcome.
Now that I reviewed my site again I remembered I wanted to ask you if one can hide the calculated result until all the fields have numbers inserted.
Here is the pic:
http://shrani.si/f/1S/iC/39CeSuN5/calc.jpg
It would be great ff those 0,000 can be hidden until the first field is given a number.
Hello @nascas
You should simply to use a conditional operation into the equation to check the fields value. I’ll try to describe the process with a hypothetical example:
Assuming your current equation is: fieldname1+fieldname2
You can edit it as follows:
IF(OR(fieldname1, fieldname2), fieldname1+fieldname2, '')
or if zero is an accepted value:
IF(OR(fieldname1|r != '', fieldname2|r != ''), fieldname1+fieldname2, '')
Best regards.
Thread Starter
Rico
(@nascas)
I have a very simple equation: PREC(fieldname2*5,1)
Hello @nascas
In this case the equation would be:
IF(fieldname2, PREC(fieldname2*5,1), '')
Best regards.
Thread Starter
Rico
(@nascas)
Thank you so much for your kind help. That worked out beautifully.
Have a nice day!