Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Insert excerpt
Define calculations
Define calculations
Info

You need admin access to the database to create calculated attributes, as the setup is done in the Administration settings. Please refer to Project and Database Administration計算属性を作成するには、データベースへの管理者アクセス権が必要です。
こちらを、ご参照ください。 プロジェクトとデータベース管理.

Item If/Then Example

You might be familiar with if/then formulas if you have ever built complex rules in Excel. The syntax of IF-THEN is = IF (logic text, value if true, value if false). The first argument tells the function what to do if the comparison is valid. The second argument tells the function what to do if the comparison is false. A quick search on the internet will result in several examples of this concept. In our example, we will use several rules to pull from item data to inform some results. If you have ever tried to determine Door Calculations, you will want to bookmark this page and impress your office. Our team in Australia came up with this idea, and we all think it’s a great example of using item data to inform other decisions.

...

Structural Height is defined using simple addition. The Reveal Height is added to the Frame architrave. But where is the Reveal Height coming from? That is another calculated attribute. Yes, you can build formulas on top of other formulas.

...

Structural Width is also defined by our first If/then formulas using Reveal Height. The rule is if the Panel B width equals zero, meaning it has no width (or there is no second panel), then combine the Revel width with the Frame architrave, AND if there is a Panel B width, add the Frame architrave twice to gain the additional width needed for both panels including the Panel B width.

...

These examples show how important project calculations can be provided to all users while simultaneously ensuring the calculations are performed.また、構造幅は、最初のIf/then式 (目標達成のための行動手法)で、高さを明らかにする (Reveal Height)
ことで定義されますルールは、パネルBの幅がゼロ、つまり幅がない場合
(または2枚目のパネルがない場合)、レベルの幅と、フレームのアーキトレーブを組み合わせます、
また、パネルBの幅がある場合は、フレームのアーキトレーブを2回追加し、
パネルBの幅も含めて両方のパネルに必要な幅を追加します。.

...

これらの例は、重要なプロジェクトの計算を、すべてのユーザーに提供すると同時に、
計算を確実に実行することを示しています。

Include Page
Text Type Calculated Attributes
Text Type Calculated Attributes

These examples aim to give you a sense of what is possible using item calculations. これらの例は、アイテム計算を使用して何が可能かを、理解していただくことを目的としています。

Include Page
Calculated Attribute Formats
Calculated Attribute Formats

Explore how to do this with Occurrence Calculated Attributes. そのための方法については、オカレンス計算属性をご参照ください。