alexpavel · Solutions Architect · 
-
Re: Ability to exclude zero values from AVERAGE calculation
Indeed, I never used the "AVERAGE" function or summary method exactly for this reason: not having the possibility to exclude the zeros. In a multidimensional database where not all the cell…1 -
Re: Force Logout & Re-authentication If Role or Permissions Change When Logged In?
@lizzyb: Although the documentation does not explicitly state that the effect is "immediate," the absence of any instruction to log out in order to observe the change implies that the effec…1 -
Re: How to calculate number of months between two dates when one date falls outside of model time range
It shouldn't be necessary the Time ranges… as in the link suggested by @luke_e For nr. of months: (Year(EndDate)*12 + Month(EndDate)) - (Year(StartDate)*12 + Month(StartDate)) + 1 Can be added +…1 -
Re: Inquiry About Connecting SFTP Server to Anaplan Data Orchestrator
Currently, ADO does not have any connectors to SFTP servers. The CSV files on which ADO can create data sources are manually uploaded from the local machine. The "nearest" connectors that y…1 -
Re: Is there a way to remove the extra empty columns in Report App?
You can upvote this idea exchange… I hope will be addressed soon: https://community.anaplan.com/discussion/155856/management-report-should-support-more-dynamic-layouts-e-g-filtering-on-columns-to-dis…1
