Crystal Report Round
I want to round off the number in crystal report like below,
31.349 to 31.300 range value(0 to 49)
31.350 to 31.400 range value(0 to 99)
how can we implement this on the crystal report?
visual-studio crystal-reports report rounding
add a comment |
I want to round off the number in crystal report like below,
31.349 to 31.300 range value(0 to 49)
31.350 to 31.400 range value(0 to 99)
how can we implement this on the crystal report?
visual-studio crystal-reports report rounding
1
Possible duplicate of Rounding numbers in Crystal report
– Nekeniehl
Nov 12 '18 at 14:02
add a comment |
I want to round off the number in crystal report like below,
31.349 to 31.300 range value(0 to 49)
31.350 to 31.400 range value(0 to 99)
how can we implement this on the crystal report?
visual-studio crystal-reports report rounding
I want to round off the number in crystal report like below,
31.349 to 31.300 range value(0 to 49)
31.350 to 31.400 range value(0 to 99)
how can we implement this on the crystal report?
visual-studio crystal-reports report rounding
visual-studio crystal-reports report rounding
asked Nov 12 '18 at 12:51
Bestin P Sebastian
1
1
1
Possible duplicate of Rounding numbers in Crystal report
– Nekeniehl
Nov 12 '18 at 14:02
add a comment |
1
Possible duplicate of Rounding numbers in Crystal report
– Nekeniehl
Nov 12 '18 at 14:02
1
1
Possible duplicate of Rounding numbers in Crystal report
– Nekeniehl
Nov 12 '18 at 14:02
Possible duplicate of Rounding numbers in Crystal report
– Nekeniehl
Nov 12 '18 at 14:02
add a comment |
2 Answers
2
active
oldest
votes
The Round() function in Crystal can accept negative argument for the number of decimals. So simply use: Round({yourNumber}, -2)
to round to the nearest 100.
actually, we don't need to round the left part of the decimal point. The second and third figure of decimals(eg: In 3.349 the figure 49, if this value is in between 0 - 49 then desired value is 3.300.If the second and third value considered together and then this value is between 50 - 99 then desired value is 3.400
– Bestin P Sebastian
Nov 13 '18 at 5:19
add a comment |
stringvar x := totext({YourFieldValue},3,"");
stringvar array y := split(x,".");
if ubound(y) > 1 then
if remainder (val(y[2]),100)>49 then
val(y[1])+((Truncate (val(y[2])/100)+1)*100)/1000
else
val(y[1])+((Truncate (val(y[2])/100))*100)/1000
I get the solution in this way.
Thought you were using the dot as a European thousand separator.
– MilletSoftware
Nov 13 '18 at 19:55
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53262581%2fcrystal-report-round%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
The Round() function in Crystal can accept negative argument for the number of decimals. So simply use: Round({yourNumber}, -2)
to round to the nearest 100.
actually, we don't need to round the left part of the decimal point. The second and third figure of decimals(eg: In 3.349 the figure 49, if this value is in between 0 - 49 then desired value is 3.300.If the second and third value considered together and then this value is between 50 - 99 then desired value is 3.400
– Bestin P Sebastian
Nov 13 '18 at 5:19
add a comment |
The Round() function in Crystal can accept negative argument for the number of decimals. So simply use: Round({yourNumber}, -2)
to round to the nearest 100.
actually, we don't need to round the left part of the decimal point. The second and third figure of decimals(eg: In 3.349 the figure 49, if this value is in between 0 - 49 then desired value is 3.300.If the second and third value considered together and then this value is between 50 - 99 then desired value is 3.400
– Bestin P Sebastian
Nov 13 '18 at 5:19
add a comment |
The Round() function in Crystal can accept negative argument for the number of decimals. So simply use: Round({yourNumber}, -2)
to round to the nearest 100.
The Round() function in Crystal can accept negative argument for the number of decimals. So simply use: Round({yourNumber}, -2)
to round to the nearest 100.
answered Nov 12 '18 at 15:12
MilletSoftware
423246
423246
actually, we don't need to round the left part of the decimal point. The second and third figure of decimals(eg: In 3.349 the figure 49, if this value is in between 0 - 49 then desired value is 3.300.If the second and third value considered together and then this value is between 50 - 99 then desired value is 3.400
– Bestin P Sebastian
Nov 13 '18 at 5:19
add a comment |
actually, we don't need to round the left part of the decimal point. The second and third figure of decimals(eg: In 3.349 the figure 49, if this value is in between 0 - 49 then desired value is 3.300.If the second and third value considered together and then this value is between 50 - 99 then desired value is 3.400
– Bestin P Sebastian
Nov 13 '18 at 5:19
actually, we don't need to round the left part of the decimal point. The second and third figure of decimals(eg: In 3.349 the figure 49, if this value is in between 0 - 49 then desired value is 3.300.If the second and third value considered together and then this value is between 50 - 99 then desired value is 3.400
– Bestin P Sebastian
Nov 13 '18 at 5:19
actually, we don't need to round the left part of the decimal point. The second and third figure of decimals(eg: In 3.349 the figure 49, if this value is in between 0 - 49 then desired value is 3.300.If the second and third value considered together and then this value is between 50 - 99 then desired value is 3.400
– Bestin P Sebastian
Nov 13 '18 at 5:19
add a comment |
stringvar x := totext({YourFieldValue},3,"");
stringvar array y := split(x,".");
if ubound(y) > 1 then
if remainder (val(y[2]),100)>49 then
val(y[1])+((Truncate (val(y[2])/100)+1)*100)/1000
else
val(y[1])+((Truncate (val(y[2])/100))*100)/1000
I get the solution in this way.
Thought you were using the dot as a European thousand separator.
– MilletSoftware
Nov 13 '18 at 19:55
add a comment |
stringvar x := totext({YourFieldValue},3,"");
stringvar array y := split(x,".");
if ubound(y) > 1 then
if remainder (val(y[2]),100)>49 then
val(y[1])+((Truncate (val(y[2])/100)+1)*100)/1000
else
val(y[1])+((Truncate (val(y[2])/100))*100)/1000
I get the solution in this way.
Thought you were using the dot as a European thousand separator.
– MilletSoftware
Nov 13 '18 at 19:55
add a comment |
stringvar x := totext({YourFieldValue},3,"");
stringvar array y := split(x,".");
if ubound(y) > 1 then
if remainder (val(y[2]),100)>49 then
val(y[1])+((Truncate (val(y[2])/100)+1)*100)/1000
else
val(y[1])+((Truncate (val(y[2])/100))*100)/1000
I get the solution in this way.
stringvar x := totext({YourFieldValue},3,"");
stringvar array y := split(x,".");
if ubound(y) > 1 then
if remainder (val(y[2]),100)>49 then
val(y[1])+((Truncate (val(y[2])/100)+1)*100)/1000
else
val(y[1])+((Truncate (val(y[2])/100))*100)/1000
I get the solution in this way.
answered Nov 13 '18 at 11:40
Bestin P Sebastian
1
1
Thought you were using the dot as a European thousand separator.
– MilletSoftware
Nov 13 '18 at 19:55
add a comment |
Thought you were using the dot as a European thousand separator.
– MilletSoftware
Nov 13 '18 at 19:55
Thought you were using the dot as a European thousand separator.
– MilletSoftware
Nov 13 '18 at 19:55
Thought you were using the dot as a European thousand separator.
– MilletSoftware
Nov 13 '18 at 19:55
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53262581%2fcrystal-report-round%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
Possible duplicate of Rounding numbers in Crystal report
– Nekeniehl
Nov 12 '18 at 14:02