Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Calculate different % if it is before specific time or after

Topic Labels: Formulas
738 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?