Difference between revisions of "Adding a dimension to a variable"
| (5 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | [[Category: | + | [[Category: Variables]] |
*Drag and drop another index node in the diagram | *Drag and drop another index node in the diagram | ||
| Line 6: | Line 6: | ||
:[[Image:Diagram Car cost1.1.jpg]] | :[[Image:Diagram Car cost1.1.jpg]] | ||
| − | * | + | *Open the attribute pane and select ‘Description’ from the [[attribute dropdown menu]]. |
:[[Image:Car cost Description.jpg]] | :[[Image:Car cost Description.jpg]] | ||
| Line 16: | Line 16: | ||
:[[Image:Car cost Definition.jpg]] | :[[Image:Car cost Definition.jpg]] | ||
| − | *Select ‘List’ from the expr popup menu. | + | *Select ‘List’ from the [[expr]] popup menu. |
*First cell is entered as 1, press ''Enter'' key twice to have 3 cells with appropriate nos. | *First cell is entered as 1, press ''Enter'' key twice to have 3 cells with appropriate nos. | ||
| Line 30: | Line 30: | ||
:[[Image:Edit table Maintenance cost.jpg]] | :[[Image:Edit table Maintenance cost.jpg]] | ||
| − | * | + | *Click <code>Year</code> from the index lists and click the <code>>></code> icon to add the index. |
*Press '''OK''' button. | *Press '''OK''' button. | ||
| Line 48: | Line 48: | ||
'''Expected: Result of <code>Maintenance cost</code> show the new changes on its cell values''' | '''Expected: Result of <code>Maintenance cost</code> show the new changes on its cell values''' | ||
| + | :[[Image:Edit table Maintenance cost1.1.jpg]] | ||
| − | |||
| − | |||
| − | |||
==See Also== | ==See Also== | ||
* [[Creating Arrays (Tables)]] | * [[Creating Arrays (Tables)]] | ||
Latest revision as of 05:02, 24 November 2023
- Drag and drop another index node in the diagram
- Type
Yearfor the index title
- Open the attribute pane and select ‘Description’ from the attribute dropdown menu.
- Type
Year of ownership - Press Alt+Enter.
- Select ‘Definition’ from the popup menu.
- Select ‘List’ from the expr popup menu.
- First cell is entered as 1, press Enter key twice to have 3 cells with appropriate nos.
- Select
Maintenance cost.
- Click on the ‘Edit table’ button that shows on the attribute pane.
- Click on the ‘indexes’ icon to bring up Indexes window
- Click
Yearfrom the index lists and click the>>icon to add the index. - Press OK button.
Expected: Edit table of Maintenance cost is now indexed by Year for the columns and Car type for rows
- Click on column 2 row header small car
- Change cell value from '1200' to ‘1500’
- Press arrow down key, change this cell value from '2400' to ‘2.6K’ { to check the number formatting is recognized}.
- Click on column 3 row header small ca
- Change the cell value from '1200' to '1.7e+3' {Same number format issue}
- Press arrow down key
- Change the cell value from '2400' to '300000%'
- Click the check button.
- Ctrl+r to bring up result table of
Maintenance cost
Expected: Result of Maintenance cost show the new changes on its cell values
See Also
Comments
Enable comment auto-refresher