TLDR: I'm not able to upgrade to a Business account, and when I go to my workspace, it says it does not belong to my company. I am the sole billable collaborator in that workspace, and I'm listed there as Owner.---I'm a consultant. A year ago, I set ...
I'm trying to format Canadian postal codes. Often the person enters them as k0e1b0. I need them to look like K0E 1B0. UPPER({PostCode}) will make them upper caseREPLACE({PostCode},4,0," ") will put the space in the middleHow can I do both of these st...
This seems like ridiculously easy formula to write, but I’m stymied.
IF({Paid} ≥ {120%}, ({Paid} - FMV),0)
If the person Paid more than 120% (120% is a column calculating 120% of the Fair Market Value), then the value of their tax receipt is the amou...
Thank you, @ScottWorld. I was not an expert at Filemaker Pro either, but I did love it and had managed to make formulas work. That probably IS why I thought ≥ would work!
Filemaker was very expensive to upgrade, though, and it was hard for my busines...
I put the spaces in because some of the examples in the help seemed to have them. The extra { }s went in in desperation.
It’s definitely the ≥ symbol that was the problem. I never would have figured that out on my own.
Thanks again.
