Highlighted
New Contributor

INV01 Module Line Item Formula Details

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. 

4 REPLIES 4
Highlighted
New Contributor

Re: INV01 Module Line Item Formula Details

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? 

Highlighted
Contributor

Re: INV01 Module Line Item Formula Details

Hi mata.israel08@gmail.com ,

 

Why dont you try NOT Current Period?, I think it should work.

 

Thanks,

Yash 

Highlighted
New Contributor

Re: INV01 Module Line Item Formula Details

I tried that but it only worked for the first year FY20 and not FY21

Highlighted
Contributor

Re: INV01 Module Line Item Formula Details

Hi mata.israel08@gmail.com ,

 

A more native approach could be:

Yash1_0-1580691803697.png

Let me know if this helps.

 

BR,

Yash