Hi,
This formula in our model is possible slowing down the load time of our model. The formula has the logic we need but I believe it can be written better for loading time in our model.
Formula:
IF
'S04 Version Mapping'.Budget
THEN
IF
'S01 Time Settings'.Funding Holidays?
THEN
IF
'S01 Time Settings'.Weekdays?
THEN
IF
WEEKDAY(START()) = 1
THEN
OFFSET(SFS Funding Final, -3, 0)
ELSE
PREVIOUS(SFS Funding Final)
ELSE
0
ELSE
'Collections Funding Dayification (Funding)'.Total
ELSE
IF
'S01 Time Settings'.Actual Date <= 'S02 Time Admin'.Last Actual Day
THEN
SFS Funding[SELECT: VERSIONS.Actual]
ELSE
IF
'S01 Time Settings'.Funding Holidays?
THEN
IF
'S01 Time Settings'.Weekdays?
THEN
IF
WEEKDAY(START()) = 1
THEN
OFFSET(SFS Funding Final, -3, 0)
ELSE
PREVIOUS(SFS Funding Final)
ELSE
0
ELSE
'Collections Funding Dayification (Funding)'.Total