Forum Discussion
Solved
Target Setting vs last year
Good Morning I am looking for help in setting target number based on period filter with value of last year, below is my scenerio I select date from 1st sep to 30th sep i got 2 values day ...
Hi,
I think a bracket is missing. Try this
=-[Sales Diff]/((EOMONTH(TODAY(),0)-TODAY())+1)
Hi Ashish
Thank you, i really appreciate the effort you put for me to understand it, just i would like to know a general or logic how it would work if possible to share
Hi,
I really cannot say. It's too large a model.