Hello, I am trying to eliminate the decimal point in my calculated field. The field is formatted as Text because the calculation takes the Fiscal Year and Period and results in "FY23P10". I thought I might fix it by adding a ROUND() expression with the Period calculation, but that did not change anything. Any help is appreciated! I included a screenshot of the custom form and my formula below.
I would try using a REPLACE expression within your formula and replace "." with nothing (i.e., "")?
@Richard_Le_ Great suggestion. I just tried that and unfortunately that gives N/A instead of FY23P10.0
Please let me know if I did this incorrectly.