Thank you, great content. The last question you only calculated the sales target met but have not checked if any of those are working days(part of the question).
In last question we first need get 'weekday names' then assign weekend and weekday and then we will have to find sales done on weekday where target is achieved. So answer is 500 sales done on 20-01-2022 which is a working day.
thanks
This video is so helpful. Thank you for sharing! Just one thing - can you also share the tables in the description if possible?
I will do that
Thank you, great content. The last question you only calculated the sales target met but have not checked if any of those are working days(part of the question).
Ya we can write that extra condition also.... Nice observation 😄
@@TechiRahul yep, trying it now.
@@TechiRahul
Please check if the below will work and the answer I got is that the sales is 500 that happened on 20/01/2022
IF ( (ISOWEEKDAY([Date]))
@@praneethrajgajula7261 correct
@@praneethrajgajula7261 all good, I think for the [Target Achieved] part you need to add = True for it to work
Sir more videos like this
Sure Brother I will
Hi Sir ..I dont see proper funtion available. I am using 2022.3.2
It's introduced in 2022.4 or later
Using
if
left(pincode,2) = ‘56’ then Bangalore -- this might be another approach
Nice brother
In last question we first need get 'weekday names' then assign weekend and weekday and then we will have to find sales done on weekday where target is achieved. So answer is 500 sales done on 20-01-2022 which is a working day.
Yup
How to contact you sir
Hi, please email your query/question
@@TechiRahul I had mailed you already sir can you please look on it
I don't see. With which email did u send?