Hi,

I couldn't find the solution to my dilemma. I want to show my value column with $value.00

see attached screenshot

is this possible?

Thanks

Hello,

Set "Columns settings -> Format" parameter to {$value}.00 value.

Regards,
ARI Soft

Sorry, I'm a bit confused.
============================
My SQL query:
SELECT ROUND(SUM(jml_hikashop_order.order_full_price),2) as " "

FROM jml_hikashop_order_product

INNER JOIN jml_hikashop_order
ON jml_hikashop_order_product.order_id=jml_hikashop_order.order_id

WHERE jml_hikashop_order_product.order_product_name LIKE '%ANGP%' OR jml_hikashop_order_product.order_product_name LIKE '%GENERAL%'
AND
jml_hikashop_order.order_status LIKE '%confirmed%'
=============================
My Column Settings:
ID: 1
Format: {$value}.00

=============================
I am totaling all values within a particular product category.

Please let me know where I am going wrong in my coding

Thanks

Set "Columns settings -> ID" parameter to 0 value.

Regards,
ARI Soft

SOLVED,

My format code works great! I just had to add "$" in front of your code to have the $ sign show along with the value.

${$value}

Thanks

If I use ${$value}, the data does not seem to sort correctly (by this column) when viewing the table. If I remove the $ mark, then it will sort correctly. Is it possible to have the $ mark show, and still sort correctly, or do I just need to remove the $ mark?