Ok. I have got the calculation as a if(expression) that works for periodicity with week and months but when it´s days the if statemeant becomes...difficult..
If(TimeUnit ='Day' AND Monday='J' AND Tuesday='J' AND Wednesday='J' AND Thursday='J' AND Friday='J' AND Saturday='J' AND Sunday ='J' , sum((('7'*DecimalTime)*'4,33')/Periodicity))
And that´s only for one combination...
Can someone help me to make it in a better way? Can I somehow convert it to a table or something?
Please see attached for one solution. Not sure what your "Time" field was so I used Hours but you can substitute for whatever you want.
Hope this helps,
Community_WeekdayJThing.qvw 151.8 K