Forum Discussion
Target Setting vs last year
- 7 years ago
Hi,
I think a bracket is missing. Try this
=-[Sales Diff]/((EOMONTH(TODAY(),0)-TODAY())+1)
appreciate your responses and feedbacks
Could you please share / calculate formula how it would be also
i wish to have another update on same report , i am adding weekdays as filter below is snap
so i would like to check if here incase i select any day then can i get a spefic target like below
so in above pic we can see i have selected Wed so logically there is only 1 wednesday in this period so my "target per day" should have been identical to "sales diff" i.e. 134,483 instead its showing 19,212 ( i have no idea from where its coming).
is there possibilty can we solve or calculate it dynamically ?
appreciate your responses.
Hi,
Your question is not clear.