Skip to main content
Closed (Won't Do)

Percentage field handling in Rules Engine

Related products:CS Rules Engine
  • March 14, 2017
  • 1 reply
  • 31 views
jean.nairon
elizabeth
devin_petrino
jaclyn_st_gemme
marcelo
+5
  • jean.nairon
    jean.nairon
  • elizabeth
    elizabeth
  • devin_petrino
    devin_petrino
  • jaclyn_st_gemme
    jaclyn_st_gemme
  • marcelo
    marcelo
  • mike_madsen
    mike_madsen
  • spencer_engel
    spencer_engel
  • dan_ahrens
    dan_ahrens
  • travis_cooper
    travis_cooper
  • nate_jones
    nate_jones

phaneendhar_lingam
In data ingestion, using COM or GS Connect or S3, whenever we ingest data to a percentage field(without percentage symbol), it is multiplied by 100 and displayed with % symbol. Consider ingesting value 0.25, it is displayed as 25%.

We are not supporting this behavior using rules, if I'm loading 0.25 from source to target - it is getting displayed as 0.25%. It should be consistent across Rules Engine and data ingestion tools.

1 reply

sundar
  • Expert ⭐️
  • 534 replies
  • March 27, 2017
Phaneendhar  - Rules Engine does not do the automatic transformation of multiplying by 100 considering the symbol because our transformation layer cannot deterministically identify whether to multiply or not. So we are not doing any automatic transformation in this scenario. 
We are adding the capability to multiply with a constant in Rules Engine formula field in Spring release with which you can do it. Right now you can do it by adding a formula in the source either in MDA or in SFDC.

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings