Formula trouble - Week left

Platform discussions Special workflows & use cases
1

Hi i’m trying to calculate number of hours left in project depends on the week number in a month -
If it’s week 1 of the month i want it to show sum of [“Project 1 Hours” - (“Project 1 monthly goal”*0.25)]
it it’s week 2 of the month i want it to show sum of [“Project 1 Hours” - (“Project 1 monthly goal”*0.5)]
if it’s week 3 of the month i want it to show sum of [“Project 1 Hours” - (“Project 1 monthly goal”*0.75)]
if it’s weeks 4 or 5 of the month i want it to show sum of [“Project 1 Hours” - (“Project 1 monthly goal”)]:

{Project 1 Hours Jan}-(IF(DAY({SYS_Date}) <= 7,{Project 1 Monthly Goal} *.25,
IF(DAY({SYS_Date}) <= 14, {Project 1 Monthly Goal} *.5,
IF(DAY({SYS_Date}) <= 21, {Project 1 Monthly Goal} *.75,
{Project 1 Monthly Goal}))))

And i get error -“illegal formula” please help to understand why ?

2

As I know, the zero before the dot (0.5) is mandatory.

3

wow thanks such a small thing, but it worked :slight_smile: