Round function

[AmirKilkr]

Hi friends,

Can you help me, please?

How do I use the round function? I am unable to fix it

example: 137.585939387663 to 137.59

Sales:
LOAD
ItemID,
"Date",
CampaignID,
DocumentNumber,
StoreHanut,
TotalPriceBeforVat,
Round(TotalPriceBeforVat),
"Time",
SalesmanID,
Quantity,

thank you

[anat]

Num(sum(sales),'##.00')

[AmirKilkr]

like this:

Round(Num(sum(TotalPriceBeforVat),'##.00')),

Doesn't work : invalid expression 

[rwunderlich · Accepted solution]

You need to specify the rounding step value

Round(TotalPriceBeforVat, .01) as TotalPriceBeforVat,

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

[AmirKilkr]

Worked perfectly and I understand what I did wrong

Thank you