Forum Discussion
Target Setting vs last year
Hi,
I think a bracket is missing. Try this
=-[Sales Diff]/((EOMONTH(TODAY(),0)-TODAY())+1)
Please see if you can get rid of unequired Tables and also reduce the number of rows.
hi
would you like to access my laptop to see the file coz i have no idea how i can reduce the table sorry about it
Hi,
That link is not accessible.
Apologies Dear I hope the below would work
https://1drv.ms/u/s!An1F3GPoODE4axa2eCndnibFAAI
Thank you
Hi,
When i click on Wedneday, the result of target per day and Sales Diff is the same. This is what you wanted.
Yes excatly but since now all wednesday are covered could you check for sunday if you can see the target would be same as sale difference ?
Hi,
My formula is correct. The problem seems to be with the relationships. It will take way too long to study all relationships. I wont be able to devote so much time.
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.