Community Chat

 View Only
last person joined: 18 hours ago 

A space for discussion around the Community site and programs.

  • 1.  Formatting Rupee Values into Lakh Format

    Posted 12-01-2023 13:39

    I'm working with a dataset containing rupee values like 200000, 5000000, 550000, and 980000. I need to transform these values into a lakh format, so the output should be 2 lakh, 5 lakh, 5.5 lakhs, and 9.8 lakhs, respectively.

    Could someone guide me on how to achieve this in Blue Prism?



    ------------------------------
    Sandy P
    ------------------------------


  • 2.  RE: Formatting Rupee Values into Lakh Format

    Posted 12-03-2023 04:39

    HI Sandy p,

     You can utilize the "Utility - Strings" VBO and action "FOrmat Number" action .

    Thanks,

    Harish



    ------------------------------
    -----------------------
    If I answered your query. Please mark it as the "Best Answer"

    Harish Mogulluri
    Lead developer
    America/New_York TX
    ------------------------------



  • 3.  RE: Formatting Rupee Values into Lakh Format

    Posted 12-04-2023 13:32

    They way I would approach this would be to use a calculation stage with something like 

    ([rupee] / 100000) & " lakh"

    This would convert your values of 200000, 550000, etc to "2 lakh", "5.5 lakh", etc.

    If you need the "s" on the end of lakh, you can have a decision after the calculation above and if the value ([rupee] / 100000) is greater than 1 (or whatever other decision you need), you can use something like [text] & "s" to add an "s" to the end of it.



    ------------------------------
    John Wilding
    Robotic Architect
    ReAssure Ltd
    Europe/London
    ------------------------------



Welcome to our 'Off-Topic' Community Chat!

A space for non-technical chat, tips for using the Community, and news from the Blue Prism Community Team.

This is not a Community for technical or Product related discussion. For a list of available communities, please visit our site map.

Introduce YourselfCommunity Tech TipsMeet The Team