Question

The expression 'ROUND("2,9935446717527325","2")' is not valid in MS-Excel formulas. For Details, please paste the expression to MS-Excel.

  • 10 April 2024
  • 4 replies
  • 17 views
P
Badge

The expression 'ROUND("2,9935446717527325","2")' is not valid in MS-Excel formulas. For Details, please paste the expression to MS-Excel..

I am facing this issue in execution , where this expression is working in Scratchbook , but it is not working in execution . 

I tried to keep the system format and excel format language settings in sync , but still the same issue .

I am facing issue with whatver CALC functions have been used . 

I had used {CALC[ROUND(""""{b[B_MinDeathTotal_BillingSheet]}"""",""""2"""")]}, but for this expression i am facing an error as mentioned above in execution

Can anyone please help.

Is there any other way to round the value ?

4 replies

Mustafa
Userlevel 3
Badge +5

Hello @Pratyusha ,

Can you please specify the software you’re facing this issue in?

Only in Death does Duty End
B
Userlevel 3
Badge +1

Use MATH instead of CALC.

{MATH[Round(<yournumber>,2)]}

https://documentation.tricentis.com/tosca/2310/en/content/tbox/calculations.htm

P
Badge

Hello,

The tool is TOSCA and local language is Dutch..but code is in English only.

I had made sure the Excel  language settings and region settings are same

P
Badge

Hi

The number format is in Dutch..so 2,993544 refers to 2.993544(decimal in dutch format refers to comma)

To use Math round first I need to convert dutch format to en format which again adds one more step.

Is there any way to do in single step

Reply


ShiftSync Terms and Conditions

Copyright ©2024 Tricentis. All Rights Reserved.