web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Problem with EVALUATE ...
Microsoft Dynamics NAV (Archived)

Problem with EVALUATE function in Dynamics NAV Web

(0) ShareShare
ReportReport
Posted on by YuliyanR 115

Hello!

I'm having trouble generating a web client report.

In the report I have a column that is options (0.1; 0.5; 1; 1.5). I'm convert this string to decimal with EVALUATE function. When you starting report in Dynamics NAV hard client, everything works and converts. But when you starting this report in Web client, I'm have problem with function EVALUATE. What could be the problem? In Web client, I'm use BG language and regional settings are Bulgaria. Web client working with comma separator and hard client with dot separator. 

*This post is locked for comments

I have the same question (0)
  • YuliyanR Profile Picture
    YuliyanR 115 on at
    RE: Problem with EVALUATE function in Dynamics NAV Web

    Thanks, Stefano. It works, but I want to fix it globally because it comes out when entering price in sales rows, purchases, timesheet lines and more.

  • YuliyanR Profile Picture
    YuliyanR 115 on at
    RE: Problem with EVALUATE function in Dynamics NAV Web

    Yes, I'm have difference between local machine and ServiceTier-Server. In ServiceTier-Server the settings are Services Language - en-US and Services Default Time Zone - UTC. In the local machine Regional settings are Bulgaria with decimal separator ('.') - dot.

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,166 Most Valuable Professional on at
    RE: Problem with EVALUATE function in Dynamics NAV Web

    If you have comma separator as regional settings, evaluate could not work with dot separator.

    The separator is treated accordingly with the regional setting.

    To process such decimal values, you can work with the NAV Command GLOBALLANGUAGE:

    Value := 0.25;

    ValStr := format(Value);

    // check for GER and FR language

    if (GLOBALLANGUAGE = 1031) OR (GLOBALLANGUAGE = 1036) then

     ValStr := Convertstr(ValStr,'.'','); // replaces the point by a comma

  • Hannes Holst Profile Picture
    Hannes Holst 5,767 on at
    RE: Problem with EVALUATE function in Dynamics NAV Web

    Sounds like as if the regional settings of the ServiceTier-Server and the local PC on which you use the Web-Client are different.

    Potentially, when you replace the comma with a dot, then it might work for you in the Web-Client too.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
Saurav.Dhyani Profile Picture

Saurav.Dhyani 2 Super User 2025 Season 2

#2
RK-25090803-0 Profile Picture

RK-25090803-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans