Remove Decimal from Calculated Field Output | Community
Skip to main content
T
Tgore08
Level 2
April 12, 2023

Remove Decimal from Calculated Field Output

  • April 12, 2023
  • 2 replies
  • 1494 views

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:

IF(({DE:Original PO Cut Period} + {DE:Periods Delayed - PO Cut Date})>13,(("FY" + ({DE:Original PO Cut Fiscal Year} + 1)) + ("P"+((({DE:Original PO Cut Period}-13) + {DE:Periods Delayed - PO Cut Date})))),(("FY"+({DE:Original PO Cut Fiscal Year}))+("P"+(({DE:Original PO Cut Period} + {DE:Periods Delayed - PO Cut Date})))))

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

KellieGardner
Community Advisor
KellieGardnerCommunity Advisor
Community Advisor
April 12, 2023

are the PO Cut Period and PO Cut Date calculated fields as well? 

T
Tgore08Author
Level 2
April 12, 2023

They are both currently dropdown fields. Number format.

KellieGardner
Community Advisor
KellieGardnerCommunity Advisor
Community Advisor
April 12, 2023

Have you tried using CONCAT with the ROUND?

R
Community Advisor
Richard_Le_Community Advisor
Community Advisor
April 12, 2023

Hi,

 

I would try using a REPLACE expression within your formula and replace "." with nothing (i.e., "")?

 

 

Best Regards,

Rich. 

T
Tgore08Author
Level 2
April 12, 2023

@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:

REPLACE(IF(({DE:Original PO Cut Period} + {DE:Periods Delayed - PO Cut Date})>13,(("FY" + ({DE:Original PO Cut Fiscal Year} + 1)) + ("P"+((({DE:Original PO Cut Period}-13) + {DE:Periods Delayed - PO Cut Date})))),(("FY"+({DE:Original PO Cut Fiscal Year}))+("P"+(({DE:Original PO Cut Period} + {DE:Periods Delayed - PO Cut Date}))))),".","")
Terms & ConditionsAccessibility statement

Loading footer...