sorry for the trivial question but was trying to figure out:
how to force aimms to show “0” values for parameters and variables/results
and correspondingly exporting those parameters to excel with “0”
at the moment, whenever the parameter or variable has “0” is appears as empty line/cell.
any hints on these two questions much appreciated!
thanks
nick
Best answer by Anonymous
Hello @Nick
As AIMMS stores data in a sparse manner, only non-default values (typically ‘0’) are stored. Similarly tables only displays those non-default values. You can adjust this by changing the Display Domain. To do so, please take a look at Display Domain property of the table at https://documentation.aimms.com/webui/widget-options.html#identifier-settings; by setting it to 1, all ‘0’ cells will also be displayed. You can also do it more fine-grained as the documentation describes.
4 replies
A
Anonymous
0 replies
Answer
January 25, 2021
Hello @Nick
As AIMMS stores data in a sparse manner, only non-default values (typically ‘0’) are stored. Similarly tables only displays those non-default values. You can adjust this by changing the Display Domain. To do so, please take a look at Display Domain property of the table at https://documentation.aimms.com/webui/widget-options.html#identifier-settings; by setting it to 1, all ‘0’ cells will also be displayed. You can also do it more fine-grained as the documentation describes.
A
Anonymous
0 replies
January 29, 2021
@Nick,
Forgot to add that also the ‘0’ will appear in the Excel file through the download CSV icon on top of the table when you set Display Domain to 1.
Example with display domain set to ‘1’ to show all non-defaults (typically ‘0’)