How to bring decimals in summation in Qliksense

sambit3 · ‎2024-09-21

I am using SUM function in Qliksense and it is rounding to nearest integer.

I want the exact sum including decimals. KIndly help

Kushal_Chawda · ‎2024-09-21

@sambit3 how many decimals do you want?

Vegar · ‎2024-09-21

I believe that the SUM only present your value as an integer, but the decimal value is still there.

You could try to adjust the presentation by adjusting the number formating in the measure properties..

OR wrap a custom format around you sum() to force a specific format. Eg: money(sum(...)) or num(sum(...),'0.00')