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},...
