How to adjust decimal values

Help Studio
, ,
1

Hello Everyone,

How we can adjust decimal values to complete 100

For example
14.29
14.29
14.29
14.29
14.29
14.29
14.29 = 100.03

Output is coming like this so i need to adjust any one amount so it can be hundred.

Thanks

2

Hi @suraj_gaikwad

Can you try this

Math.Floor(100.03)

The image shows a message box in a software displaying the result "100" from the mathematical operation . (Captioned by AI)
The image shows a message box in a software displaying the result "100" from the mathematical operation . (Captioned by AI)649×242 7.15 KB

Regards,

3

Hi you can convert your value to integer
Using Cint(100.03)

Or convert.toInteger

You can use round off function also and set limit to 0
@suraj_gaikwad

4

@suraj_gaikwad

use like this…

anyoneamount = If(Total>100,anyoneamount-(total-100),anyoneamount+(total-100))

here anyoneamount is the amount from one of the 14.29 that you want to adjust…total is the actual total

cheers

5

@suraj_gaikwad,

Assuming you are storing the decimal values into an decimal array.

Here is a solution
Code:

The image is a flowchart of a process in a visual programming environment that initializes an array, logs and sums its values, checks if the sum exceeds 100, adjusts the first element if it does, and logs the final values and sum. (Captioned by AI)
The image is a flowchart of a process in a visual programming environment that initializes an array, logs and sums its values, checks if the sum exceeds 100, adjusts the first element if it does, and logs the final values and sum. (Captioned by AI)927×1274 59 KB

Output:

The screenshot displays an output log from a debugging session, showing input and output values, along with sums calculated before and after execution, indicating the results of a test bot's operations. (Captioned by AI)
The screenshot displays an output log from a debugging session, showing input and output values, along with sums calculated before and after execution, indicating the results of a test bot's operations. (Captioned by AI)712×829 32.3 KB

Sample Project:
TestBot.zip (148.2 KB)

6

Hi

Basically I’m using this code

IMG20241201005452
IMG202412010054521920×1440 410 KB

After this i have to put one by one value on portal of total amount is hundred if not hundred then i have to adjust any value which will be come

@ashokkarale
@Anil_G
@jast1631
@lrtetala

Thanks everyone

7

@suraj_gaikwad,

Ok so you will have the values in a datatable right?

8

Yes ,

The values are not fix its changes
@ashokkarale

9

Hello guys

Anyone knows how i can handle this

@ashokkarale @lrtetala @jast1631 @Anil_G

Thanks

10

@suraj_gaikwadm,

Here is my modified solution with Datatable as source.

This image shows a flowchart of activities and decision-making logic in an automated data processing workflow, illustrating data table construction, value summation, condition checks, data logging, and updates based on sum values. (Captioned by AI)
This image shows a flowchart of activities and decision-making logic in an automated data processing workflow, illustrating data table construction, value summation, condition checks, data logging, and updates based on sum values. (Captioned by AI)927×1711 77.2 KB

Output:

The image shows a debug output log from a TestBot execution, displaying initial and modified values in a column, as well as their summed totals before and after execution. (Captioned by AI)
The image shows a debug output log from a TestBot execution, displaying initial and modified values in a column, as well as their summed totals before and after execution. (Captioned by AI)1043×883 36.3 KB

Source Code:
TestBot.zip (163.6 KB)