nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Formating an expression

spg2112

Hey all, 
 
Could someone help me with this expression? I just want to format the calculated portion as currency. Thanks! 
 
"Net Due Company "+"("+dataSetRow["DISPLAY_NAME"]+") "+Format((row["Aggregation_2"]-row["PreviousPayment"]+dataSetRow["QSE FEE"]),"$#,###.00") 
 
Steve

Find more posts tagged with

Comments

Hans_vd

Hi Steve,

How about this:

"Net Due Company "+"("+dataSetRow["DISPLAY_NAME"]+") " + new Packages.java.text.NumberFormat.getCurrencyInstance().format(row["Aggregation_2"]-row["PreviousPayment"]+dataSetRow["QSE FEE"])

Hope this helps

Regards
Hans

spg2112

Hans thank you... works perfectly!

Steve

Hans_vd

Yeah, at Sunday night I'm at my best :-)