chandra | Reputations

Posted an answer
What-If analysis: Only use whole numbers.

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...

December 12, 2019 5
Received an upvote
October 21, 2019 2
Selected an answer as best
October 21, 2019 2
Answer was selected as best
October 21, 2019 10
Selected an answer as best
October 21, 2019 2
Answer was selected as best
October 21, 2019 10
Posted an answer
Would you give an example of if-else statement in ValQ?

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...

October 21, 2019 5
Posted an answer
‘Export to PDF’ option for valQ visual from Power BI Services

Currently 'Export to PDF' or 'Export to Powerpoint' is not supported. However, the models can be downloaded as a Microsoft Excel-compatible XML file.

September 11, 2019 5
Posted an answer
Is there any limit for Custom Time Period ?

Yes, it is possible to bring in 36 months of data. There is no limit on the number of periods.

September 10, 2019 5
Posted an answer
Deciding ‘Constraints’ in Nav Panel

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...

September 10, 2019 5
Posted an answer
Can we Change how the way Charts calculate Variance

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...

September 9, 2019 5
Posted an answer
Time Aggregation ‘Average’ v/s Weighted Average Node

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...

September 6, 2019 5
Posted an answer
Will simulation input type ‘Constant’ only work on nodes that have calculation method as ‘Manual’ ?

There is no such restriction. It works on all nodes immaterial of whether the node consumes data from data source, is calculated using a formula, linked to node, templated based on another node, or takes...

September 6, 2019 5
Received an upvote
September 4, 2019 2
Posted an answer
Query related to ‘Max’ & ‘Min’ options in Node Configuration

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....

September 4, 2019 5
Received an upvote
September 4, 2019 2
Posted an answer
Difference between 2 types of simulation inputs?

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...

September 4, 2019 5
Selected an answer as best
August 20, 2019 2
Answer was selected as best
August 20, 2019 10
Received an upvote
Want to change the color of Node Connectors, is that possible ?

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...

August 20, 2019 2
Load More