Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Please help me to get correct logic
COUNT({<FINALWEEKDAY -= {'Sun','Sat'},FINAL_FLAG = {'WORKINGDAY'}>}DATE(Today(),'DD-MM-YYYY') - ZDATE_FROM)
Thanks For Response
This is Not possible in Front end and i done at back end
what error are you getting
For eg
01.07.2020 to 31.07.2020
here exclude holiday ,sat and sun value is 23 that's correct
Now i need to show 01.07.2020 to today that count is 17
i Hope you understand
Try this
COUNT({<FINALWEEKDAY -= {'Sun','Sat'}, FINAL_FLAG = {'WORKINGDAY'}, ZDATE_FROM= {">=$(=MONTHStart(today()))<=$(=Today())"}>} ANYDIMENSION)
Thanks for your responce
here you are hardcode and apply monthstart but here we are having different starting and not apply direct monthstart at all time.
Hi, maybe Networkdays() function canhelp you, it counts ays between dates and you can pass holidays as parameters to avoid to count them:
From your current expression, if you have a master calendar that has a field DATE with all the dates with the flags you can do something like:
COUNT({<FINALWEEKDAY -= {'Sun','Sat'},FINAL_FLAG = {'WORKINGDAY'}, DATE={">=$(=Max(ZDATE_FROM))<=$(=Today())"}>} DATE)
But this won't work if you have a table with different ZDATE_FROM because set analysis is calculated for the whole table, not row by row.
Thanks For Response
This is Not possible in Front end and i done at back end