I need to calculate of sale, number of units sold per week.if i select last year, then it shoould be retail quanity /52(number of weeks in a year). if i select current year from period filter, suppose current month is jan then calculation be like retail quantity/4(number of weeks in jan month) if current month is aug then calculation should be retail quanity/36(number weeks till august) and if the current month is oct then calculation be like retail quantity/40(number of weeks till oct). Attaching you the qvw file for your refrence.
I'm unsing the below code,with this i'm not getting the desried output. This problem is on the sales tab and ros text object in the dashboard
This will also kick the post back up to where someone else may have another look at things too.
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.