Help
Formulas
cancel
Showing results for 
Search instead for 
Did you mean: 

Formulas Activity

Techniques

Project teams can use different techniques to capture and manage requirements. Microsoft Azure DevOps work items and GitHub issues are commonly used to facilitate the collaboration on the requirements by the project team. Additionally, tools are avai...

  • 12 Views
  • 0 replies
  • 0 kudos

Define the different functional table types and characteristics

As a business management application, Business Central manages and processes a considerable amount of data, all of which is stored in tables. From a technical perspective, all tables are the same because they all contain fields, keys, and triggers. F...

  • 13 Views
  • 0 replies
  • 0 kudos

Introduction

This module provides an overview, from a functional point of view, of the different table types in Business Central.When developing tables, you'll use of a number of standards or design patterns. For example, setup tables contain setup information an...

  • 16 Views
  • 0 replies
  • 0 kudos

Resolved! IF Formulas Help

Hello. I'm trying to create an IF formula that returns some text if the date field is a specific date. Each date would need its own specific text.e.g. If my date field was 05/01/2025, then the IF formula field would return specfic text (e.g Day 1).Th...

  • 107 Views
  • 2 replies
  • 0 kudos

Resolved! Combining Dates from Multiple Fields

We're a publishing company and we keep track of content that we publish over the course of the year with these different columns showing publish dates. I'd like to do 2 things:Create 1 column that combines the dates (combining them so that they remai...

  • 228 Views
  • 5 replies
  • 0 kudos

Tracking Annual Fees and Sending Reminder emails

Hello everyone,Newbie here! I'm trying to create a base that can track all the annual membership payments and also send them an automatic email 2 weeks before the renewal date (based on the MEMBERSHIP JOINING DATE) is due, plus two more reminder emai...

  • 100 Views
  • 1 replies
  • 0 kudos

Revenue Formula Rounding Randomly

Revenue = Quantity * Price7496.90 = 150 * 49.98Why is the number rounding up to 7497.00????Another Example: $205.80 = 25 * $8.23The value I get in my Revenue Cell is rounded down to $205.75.Here is the revenue formula vs. what it should be. The numbe...

sibbotso_0-1732559442557.png sibbotso_0-1732562854558.png
  • 245 Views
  • 4 replies
  • 0 kudos

Resolved! Please help! IF formula with negative numbers

I'm trying to score based on a percentage another field is calculating.If Profitability is greater than 0%, score 2.If Profitability is between -5% and 0%, score 1.If Profitability is less than -5%, score 0.I can get it to work for greater than 0% an...

  • 181 Views
  • 3 replies
  • 0 kudos

Automatically Selecting Multiple Selections in a New Cell

We are a publishing company and we publish individual pieces of content on multiple dates.  I have a different sheet that I'd like to have all of those dates be put together into 1 cell (see attached). Is there a way to do that so that if I fill in a...

  • 274 Views
  • 5 replies
  • 0 kudos