Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
I have a kpi with a metric that is showing in millions like 35.76 M. how can I change this to only show 36 M( from 35.76 approximate to 36 M)
My measure it is configured to showa number 1,000 but for millions shows 35.76 milions.
thank you
Try this
Round(Sum(YourMetric) / 1000000, 1) & ' M'