Appreciate your help arvindgarg
Firstly, The Solution you gave went over my head!
Secondly, Can your logic be replicated for Monthly and Quarterly?(If yes How as I could not understand your logic)
I am trying something like this( Please see the attached work book)
Please let me know if I am on the right path or your solution would make more sense.
Thanks for the response.
Requirement 3.twbx 107.6 KB
can you check and confirm if the solution for weekly is correct.
I mean, are you getting correct data?
The calculation is correct and is representing right data but the only thing here is I have lot more conditions to apply on calculated filed like I stated above.
Please direct me.
The calculations look good but they are over my head. I could not
understand them what you are trying to do.
Could you please elaborate one logic?
On Sat, Feb 3, 2018 at 11:16 PM, arvindgarg <firstname.lastname@example.org>
1 of 1 people found this helpful
It is very simple, YOu should bring all relevent columns to a sheet and analyze things
such as comparing weekly checks selected week and give true and false.
For monthly calculation, we need last data of week - we get it from Last date of week data item.
i hope it gives you some idea