How to Subtract value in filemaker?
I have added a column and declared as calculation and the field name is subtrac. It has to be the value of (total cost - vendor paid). I have a column called vendor status(Paid/Unpaid). If the vendor paid status is "Unpaid" then only the calculation should take place.Else it should return 0. how to write the code? Please help me out.I'm new to it.