Thousand Separator for Card Widget

Technical queries
#1

Hello Team Helical,

I am using Helical Insight 4.0 version. I am using a card widget and I want to have a thousand separator for the number. How can I do this?

Thank You
Krishna

1 Like
#2

Hello Krishna,

There is no default option currently available. However, you can achieve this by using the following in a custom column:

CONCAT('$',FORMAT((sum(coalesce(aftermarket_price, aftermarket_replace, aftermarket_replace1, 0) * QTY)),0))

Please Note: The syntax may vary depending on the database that you are using.

image

Thank You
From Team Helical Insight