Formula Question




I'm trying to create a formula that will pull values in accordance to each weekday. Below is the Formula I'm currently using. I have screen shots of the Modules I'm pulling from as well. If you need more information on the topic please let me know. 


'D01 Funding Ratios'.Average of Fund * '01S03 Weekday count by month'.Monday Dayification'.Daily Funding * '


Thank you 


  • TimPeterson

    Am I correct that currently you are just taking an average/proportional amount based on the number of times a day occurs in a month, but would like a formula to exactly total the amount that occurs on each weekday?

    If yes, then in what format is your intended source module? Time dimensioned by days or a flat transaction module with day/date as an attribute?