new

  

Need to duplicate a scenario? Need to copy assumptions from one country to another? We just launched an awesome feature to clone data.

---

Read more on Pigment's Help Center

new

  

So far, formatting was only available at the metric level. To give you more flexibility, we made it possible to format single rows, columns, or cells. You can now select Column headers, Row headers or any single cell and apply formatting thanks to a nice, floating formatting toolbar. Let's paint!

improvement

  

So far, you could only duplicate blocks with their basic configuration (List properties, Metric dimensions). Now, you can will also duplicate data, formulas and views.

improvement

  

Block settings are now displayed in a modale rather than a dedicated page. You no longer need to exit a view to rename, change the type or dimensions of an object or see the usage of this object.

improvement

  

Files generated with CSV Exports are now named after the block name.

new

  

You can now create, configure and load data in your new lists using the Create from CSV… feature.

new

  

You can now choose to display negative values with the minus symbol or between parenthesis. This option is available in the Configuration panel, under the Display options:

new

  

Displaying data in thousands or millions has never been so easy. In just a few clicks, you can format your values as you wish.

Open the Configuration panel, then Display options. You can chose to display your values in thousands (k), millions (M) or billions (B):

new

  

You may need to use the same metric in multiple tables. But you may want to display it differently from one table to another.
Take costs for example. You may want to display them as negative items in a P&L but as positive items in cost analysis or reviews to ease the reading. On Excel or other softwares, you would need to duplicate your metric and multiply it by -1.
Here, we created a feature called "Reverse signs," in the Display options, so that you can reuse a metric and simply toggle this option if you need to invert values :

new

  

When looking at numbers, we often need to calculate ratios. Previously, the only way to calculate a ratio was to create a new block (property of metric) and input the formula ratio in the formula bar.

To make this easier, we created a Show value as… feature. You can now calculate ratios in just a few clicks, rather than using a formula.

To access this feature, right click on the header of any metric: