Help

Calculate different % if it is before specific time or after

Topic Labels: Formulas
646 2
cancel
Showing results for 
Search instead for 
Did you mean: 
shasixz
4 - Data Explorer
4 - Data Explorer

Can anyone please help me solve this issue? Before 1/1/2024 I have to calculate a 2.99% fee and after is different 2.29%. I am trying a formula but only giving the result after 31/12/2023, before the result is blank:

 

IF(
    {Date Booked},
    IF(
        IS_AFTER(
                {Date Booked},
                DATETIME_PARSE(
                    '31/12/2023',
                    'DD/MM/YYYY'
                    )
                ),
({Total due}-(2.29*{Total due})/100)+{Manual Rate}),
IF(
           IS_BEFORE(
                {Date Booked},
                DATETIME_PARSE(
                    '1/1/2024',
                    'DD/MM/YYYY'
                    )
                ),
({Total due}-(2.99*{Total due})/100)+{Manual Rate})
)
2 Replies 2
shasixz
4 - Data Explorer
4 - Data Explorer

Is there any moderator that can assist with this?

shasixz
4 - Data Explorer
4 - Data Explorer

I keep trying but is hard, anyone to give me an idea how to solve this?