Skip to main content
zach_davis
Helper ⭐️
Mar 5, 2018 6:01 PM UTC
New Idea

CAST String to Number in Bionic Rule

Would it be possible to add the CAST function to transformation tasks in Bionic Rules?

Example: Customer has a CSAT in SFDC but is stored as a String rather than Number. In order to calculate anything off of this, I have to load to the MDA using 10 Actions in a Rule since I cannot load a String to a Number field in the MDA.

I would like to be able to convert these to numbers in a Transformation task. Thoughts?

    3 replies

    jitin_mehndiratta
    Helper ⭐️⭐️⭐️
    Jul 10, 2018 10:42 AM UTC
    Thanks Zach. We are enhancing our formula builder incrementally with each release to support new formulae. I will update you when this gets prioritized.
    Translate
    matthew_lind
    VIP ⭐️⭐️⭐️⭐️⭐️
    Sep 28, 2022 1:50 PM UTC

    It’s awesome this functionality has made it to Data Designer. It would be tremendous to see the Rules Engine keep pace by having a “ToNumber” style of functionality in the Rules Engine too.

    Translate
    Making people their best....currently disguised as a CS Ops Architect. How can I contribute to your success?
    Jef Vanlaer
    Helper ⭐️⭐️⭐️
    Sep 28, 2022 3:02 PM UTC

    Needed this today. Had to use a work-around doing it in Data Designer and then updating fields on the original object via Rules Engine.

    Translate