Hi, Let's consider a scenario where tax rate is assigned a value based on the Net Sales. This can be modelled using an if-else statement as shown in the image. Take a look at our sample model 'P&L...
View Question
chandra | Answers
chandra
137 Rep.
Setting 'Max' and 'Min' values does not restrict simulation. It only highlights the node in red in the Constraints section of the Navigation Panel if the value does not fall within the range specified....
View Question
Pct Change to baseline applies the simulation applied for the current period to all the periods. For example, let's say we simulate Copper sold for Jan by 5%, the same 5% increase gets applied for all...
View Question
It is possible to change the color of the node connectors. To do this, go to Settings -> Color Theme. In the Tree Widget section, click on the icon next to connectors. In the pop up that opens, you...
View Question
Let's consider a node Full Time Employees. To simulate click on the icon higlighted in the below image. The dialog box opens. Click on the Edit icon. In the dialog box that opens, you can manually...
View Question
Currently 'Export to PDF' or 'Export to Powerpoint' is not supported. However, the models can be downloaded as a Microsoft Excel-compatible XML file.
View Question
Yes, it is possible to bring in 36 months of data. There is no limit on the number of periods.
View Question
It is not required to select the node under ‘Constraint’ tab of navigation Panel from Settings. Entering Min and Max values in the Node Configuration automatically ensures that the specific node is...
View Question
Currently we do not have an option to change the way variance is calculated. However, it is in the product roadmap. It should be possible to customize the variance calculation by using the enhanced formula...
View Question
On choosing 'Average' as 'Time Aggregation', you can either display simple average or weighted average. For simple average, in the 'Weighted Average Node' field, choose 'None'. If you want to display...
View Question