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.
Formula:
Views
Replies
Total Likes
are the PO Cut Period and PO Cut Date calculated fields as well?
Views
Replies
Total Likes
They are both currently dropdown fields. Number format.
Views
Replies
Total Likes
Have you tried using CONCAT with the ROUND?
Views
Replies
Total Likes
Hi,
I would try using a REPLACE expression within your formula and replace "." with nothing (i.e., "")?
Best Regards,
Rich.
Views
Replies
Total Likes
@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.
Formula:
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies
Views
Like
Replies
Views
Likes
Replies
Views
Like
Replies