Skip to main content
SharePoint

Return to Question

added 103 characters in body
Source Link
MarkR
MarkR
  • 15
  • 5

I have a calculated field which is filled in automatically thanks to a simple formula:

=(X*X*Z/162-Y*Y*Z/162)*X

This generate a number like: 1.637.037 I have a problem on adding RIGHT function to remove first 4 char from right to left and leave the number like 1.637 or like 1.637,03 by adding the comma.

Can anyone help me?

enter image description here Thanks

ThanksUpdate

enter image description here

enter image description here

I have a calculated field which is filled in automatically thanks to a simple formula:

=(X*X*Z/162-Y*Y*Z/162)*X

This generate a number like: 1.637.037 I have a problem on adding RIGHT function to remove first 4 char from right to left and leave the number like 1.637 or like 1.637,03 by adding the comma.

Can anyone help me?

enter image description here

Thanks

I have a calculated field which is filled in automatically thanks to a simple formula:

=(X*X*Z/162-Y*Y*Z/162)*X

This generate a number like: 1.637.037 I have a problem on adding RIGHT function to remove first 4 char from right to left and leave the number like 1.637 or like 1.637,03 by adding the comma.

Can anyone help me?

Thanks

Update

enter image description here

enter image description here

added 91 characters in body
Source Link
MarkR
MarkR
  • 15
  • 5

I have a calculated field which is filled in automatically thanks to a simple formula:

=(X*X*Z/162-Y*Y*Z/162)*X

This generate a number like: 1.637.037 I have a problem on adding RIGHT function to remove first 4 char from right to left and leave the number like 1.637 or like 1.637,03 by adding the comma.

Can anyone help me?

enter image description here

Thanks

I have a calculated field which is filled in automatically thanks to a simple formula:

=(X*X*Z/162-Y*Y*Z/162)*X

This generate a number like: 1.637.037 I have a problem on adding RIGHT function to remove first 4 char from right to left and leave the number like 1.637 or like 1.637,03 by adding the comma.

Can anyone help me?

Thanks

I have a calculated field which is filled in automatically thanks to a simple formula:

=(X*X*Z/162-Y*Y*Z/162)*X

This generate a number like: 1.637.037 I have a problem on adding RIGHT function to remove first 4 char from right to left and leave the number like 1.637 or like 1.637,03 by adding the comma.

Can anyone help me?

enter image description here

Thanks

added 4 characters in body; edited tags
Source Link
Ganesh Sanap - MVP
Ganesh Sanap - MVP
  • 46.4k
  • 22
  • 31
  • 63

I have a calculated field which is filled in automatically thanks to a simple formula:

=(XXZ/162-YYZ/162)*X

=(X*X*Z/162-Y*Y*Z/162)*X

This generate a number like: 1.637.037 I have a problem on adding RIGHT function to remove first 4 char from right to left and leave the number like 1.637 or like 1.637,03 by adding the comma.

Can anyone help me?

Thanks

I have a calculated field which is filled in automatically thanks to a simple formula:

=(XXZ/162-YYZ/162)*X

This generate a number like: 1.637.037 I have a problem on adding RIGHT function to remove first 4 char from right to left and leave the number like 1.637 or like 1.637,03 by adding the comma.

Can anyone help me?

Thanks

I have a calculated field which is filled in automatically thanks to a simple formula:

=(X*X*Z/162-Y*Y*Z/162)*X

This generate a number like: 1.637.037 I have a problem on adding RIGHT function to remove first 4 char from right to left and leave the number like 1.637 or like 1.637,03 by adding the comma.

Can anyone help me?

Thanks

Source Link
MarkR
MarkR
  • 15
  • 5