This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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( ...
I have a formula that calculates a 2.99% but since January 1 is 2.29%. Actual formula: ({Total due}-(2.99*{Total due})/100)+{Manual Rate}I have a column: Date Booked How can I modify the actual column named 2.99% to be calculated only if the Date Boo...
I am so desperate, I can not find a way to make it work. right now is only giving me the 2.29% result and the 2.99% is empty:IF({Date Booked},IF(IS_AFTER({Date Booked},DATETIME_PARSE('31/12/2023','DD/MM/YYYY')),({Total due}-(2.29*{Total due})/100)+{M...
I am trying my best but is not working: IF( AND( IS_AFTER( {Date Booked}, '1/1/2024' ), {Date Booked}, ({Total due}-(2.29*{Total due})/100)+{Manual Rate}, IS_BEFORE( {Date Booked},...