Forum Discussion
How to calculate dynamically Changing week
Hi, Need to find dynamically changing week i.e., need to display previous week(sales) vs current week(sales) against fiscal year.
Hi PavithraShan,
For your requirement, you can use year and weeknum to find out correspond week to calculate:
If you confused about coding formula, can you share some dummy data to help us clarify your data structure and test?
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng