Discussion Board for collaboration related to QlikView App Development.
How do I get the order number of today's day, when it is the 140th day of the year (20/5/2009)?
My purpose is to calculate an annualized number of a product's consumption, when I get the updated YTD consumption every day from ERP:
YTD consumption x 365 / <day number of today> = annualized consumption.
Try this formulae =today()- YearStart(today()).
i think this should help you.
View solution in original post
It works! Thanks!