Formula Question

neg177
neg177
in Modeling

Hi,

 

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 

Tagged:

Answers

  • TimPeterson
    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?

Categories