+2Hello, I want to calculate the total cost per tickets ONLY IF they are a specific type, and then I want to deduct that from a total amount that I set manually. My fields are currently set up:
Total tickets (# field)
Per ticket cost ($ currency)
Total cost (simple formula: {Per ticket Cost}* {Total Student tickets})
Revenue source (single line text)
Right now, I have "IF({Revenue Source}="X", {Total cost}-40,000)", but it's returning 0. Any tips? Thank you!!
+31Any chance you could share a screenshot so I can help with troubleshooting? Or if you could provide a link to a base with example data that would be excellent
+22Hey @Shirley_Kawafuc!
I think that the comma in your 40,000 value could be causing unexpected problems.
Try this:
IF(
{Revenue Source} = "X",
{Total cost} - 40000
)+2Thank you so much @Ben_Young1 and @TheTimeSavingCo! Removing the comma fixed the formula. I'd like the "Deduct Formula" column to continue subtracting from my set total of $40,000 budget IF there is a "Total cost" associated with student tickets (see screenshot). By chance do you know to achieve this? Do I need to add a hidden column that holds just the set budget amount?
+22Thank you so much @Ben_Young1 and @TheTimeSavingCo! Removing the comma fixed the formula. I'd like the "Deduct Formula" column to continue subtracting from my set total of $40,000 budget IF there is a "Total cost" associated with student tickets (see screenshot). By chance do you know to achieve this? Do I need to add a hidden column that holds just the set budget amount?
Hey @Shirley_Kawafuc, are you looking to get something along the lines of this?
+2Hi @Ben_Young1 , yes! The only change is: I want the "Remaining Budget" amount to get smaller and smaller as the total costs accrue, instead of each line starting over from $40,000 every time.
+2Weirdly, for some reason, my Deduct formula column isn't working now. In screenshot, you'll see the amounts it's giving are incorrect. I have the formula set up like:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.