Solved

Displaying "0" values

  • 23 January 2021
  • 4 replies
  • 79 views

hi all,

sorry for the trivial question but was trying to figure out:

  1. how to force aimms to show “0” values for parameters and variables/results
  2. 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

icon

Best answer by Gertjan 25 January 2021, 22:24

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.

View original

4 replies

Userlevel 6

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.

Userlevel 6

@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’)

 

Hello Gertjan, thank you so much for your help and responses. I believe this is done in web UI but how to set display domain in Aimms IDE/developer?

 

thanks

 

Userlevel 6

I think this older Google post gives you the answer for the pivot table inside the IDE:

https://groups.google.com/g/aimms/c/CGxumZnLlpI

 

Reply


Didn't find what you were looking for? Try searching on our documentation pages:

AIMMS Developer & PRO | AIMMS How-To | AIMMS SC Navigator