Want to calculate percentage for users added

[Ash41]

Hi, 

I have 2 fields, "Max Users count" field with integer type and "MAX user Volume %" field with string. These fields are on some x table, same table is related to sys_user table. 

If any update in "Max Users count" field

for example: 100

then field "MAX user Volume %" should update as 100%, 

I want to calculate Percentage on "MAX user Volume %" based on the value in "Max Users count" field. Please help

[Hemanth M1]

Hi @Ash41 ,

You just want add % to the Max User count and update on to the MAX user Volume field??

looking at your example it just adds % if so , just configure a BR/flow when Max User count changes , add same value with % 

if not whats the Percentage canculation logic??? 

need more info here

[Bert_c1]

Here's script logic if you choose to do that in a business rule

var intValue = 100;
var intStr = intValue.toString();
intStr += "%";
gs.info('intValue = ' + intValue + ', intStr = ' +intStr);

If used in a business rule, delete line 1 and change line 2 to 

var intStr = current.u_max_user_count.toString();

use the correct column name for u_max_user_count.

[Ash41]

Hi, 

Sorry may be my example was wrong in question.

what ever value is given in "Max Users count" field is should be considered as 100%. 

Then, there is one more field it should populate percentage of users added to table sys_user table based on "Max Users count" field.

[Ash41 · Accepted solution]

created new field and calculated % of field, issue resolved