SL 360 calculations & JS formatting

Javascript's toLocaleString function supports this functionality. For example,

(1234567.0987).toLocaleString();

You may need to change the variable types to string to receive the converted type as it's a text string, not a number

Hi Blue,

Here's a way. I don't know JS too well, so cobbled together some things, among them to round each amount to avoid having decimal places in your numbers.

I added three text variables, as you need them to contain the values with commas.

https://360.articulate.com/review/content/d33a8dd2-c18a-4786-b4b9-6af162138ca6/review

The JS is here:

var player = GetPlayer();

function formatNumber(num) {
return num.toString().replace(/(\d)(?=(\d{3})+(?!\d))/g, '$1,')
}

var FP_Amt_JS = player.GetVar("FP_Amt");
var FP_Tax_JS = Math.round(FP_Amt_JS * 0.30);
var FP_Net_JS = Math.round(FP_Amt_JS - FP_Tax_JS);
var FP_Week_JS = Math.round(FP_Net_JS / 52);

player.SetVar("Tax_text",formatNumber(FP_Tax_JS));
player.SetVar("Net_text",formatNumber(FP_Net_JS));
player.SetVar("Week_text",formatNumber(FP_Week_JS));

Thanks Brian, and David. That works lovely, I'm taking out the rounding as I need the decimal place, but that is just what I needed, thank you SO much!

I'll repost the JS code once I've re-added the decimal to 2 points.

This is the code I used to calculate the values as needed, and split with commas, and also only have 2 decimal places. Thank you for your help.

var player = GetPlayer();

function Commas(x) {
 var parts = x.toFixed(2).split(".");
 parts[0] = parts[0].replace(/\B(?=(\d{3})+(?!\d))/g, ",");
 return parts.join(".");
}

var FP_Amt_JS = player.GetVar("FP_Amt");

var FP_Tax_JS = FP_Amt_JS * 0.30;
var FP_Net_JS = FP_Amt_JS - FP_Tax_JS;
var FP_Week_JS = FP_Net_JS / 52;

player.SetVar("Tax_text",Commas(FP_Tax_JS));
player.SetVar("Net_text",Commas(FP_Net_JS));
player.SetVar("Week_text",Commas(FP_Week_JS));

Very cool! Thanks for sharing that!