QlikView App Dev

[Learnerr]

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]

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

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

-Rob

[Learnerr]

Hello,

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

[vinieme12 · Accepted solution]

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