Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You need to specify the rounding step value
Round(TotalPriceBeforVat, .01) as TotalPriceBeforVat,
-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com
Num(sum(sales),'##.00')
like this:
Round(Num(sum(TotalPriceBeforVat),'##.00')),
Doesn't work : invalid expression
You need to specify the rounding step value
Round(TotalPriceBeforVat, .01) as TotalPriceBeforVat,
-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com
Worked perfectly and I understand what I did wrong
Thank you