I'm having trouble with these formulas.
for the Not 1st week of Timescale? line item in the SYS01 Time Settings By Week, I was using the formula
NOT Current Period? but I don't think this will work because that will just apply for FY20 and not FY21 and so on.
I was thinking of using WEEKVALUE but I got an error.
I'm stuck. on this and the next sections Activity: Build TRA01 Shipping Metrics by Week ModulePage
INV01 Module Line Item Formula Details, could I get some help?
Hi firstname.lastname@example.org ,
Why dont you try NOT Current Period?, I think it should work.
I tried that but it only worked for the first year FY20 and not FY21
A more native approach could be:
Let me know if this helps.