Skip to main content
Solved

Displaying "0" values

  • Jan 23, 2021 4:07 PM UTC
  • 4 replies
  • 781 views

Forum|alt.badge.img

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

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.

View original

4 replies

  • Answer
  • Jan 25, 2021 9:24 PM UTC

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.


  • Jan 29, 2021 4:27 PM UTC

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

 


Forum|alt.badge.img
  • Author
  • Explorer
  • Feb 2, 2021 10:13 AM UTC

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

 


  • Feb 2, 2021 11:52 AM UTC

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

 


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

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