topic Text Object Number Format in QlikView

Text Object Number Format

Learnerr — Wed, 01 Jun 2022 14:40:54 GMT

Hi experts,

I am trying to show a calculation within my text object but the representation of the result is soooo long. How can i minimiza its length please:

=Sum( {<SATIŞ_YIL2={"2021"}>} (Yükseklik*Genislik*Uzunluk/1000000000)* Num ( FATURALANAN_MIKTAR, '#.##0,##', ',' , '.' ))

#numbers#format#

Thanks,

Best Regards.

rwunderlich — Wed, 01 Jun 2022 15:14:23 GMT

The Num() function goes outside the Sum(). Like

Num(Sum(...), '#.##0,##')

-Rob

Learnerr — Fri, 03 Jun 2022 06:30:23 GMT

Hello,

Thanks for your answer. I put num at the beginning of my block yet nothing has changed unfortunately.

vinieme12 — Fri, 03 Jun 2022 06:53:00 GMT

=Num(Sum( {<SATIŞ_YIL2={"2021"}>} Yükseklik*Genislik*Uzunluk* FATURALANAN_MIKTAR)/ 1000000000 , '#.##0,##', ',' , '.' )