Innofalls Documentation
Back to WebsiteOpen Ticket
  • 🎉Overview
  • ▶️Getting Started
    • Installation
    • Create Your First Waterfall
    • Data Fields
      • Values From
      • Stack / Columns
      • Delta Fields
    • Videos
  • 🧭Interactivity
    • Navigation
      • Navigation Menu
      • Keyboard Shortcuts
      • Drill Down History
      • Drill Down Preview
    • Selections
    • Dynamic Deviation Charts
    • Sorting and Top N
    • Highlighting
    • Restrict User Controls
    • Animations
  • 📊Chart Types
    • Overview
    • Waterfall Charts
      • Running / Intermediate Total Waterfalls
      • Intermediate Totals and Sub Totals
      • Delta Waterfall Charts
      • Measure Delta Waterfall Chart
      • Deviation Waterfall Charts
    • Other Chart Types
      • Bar Charts
      • Stacked Bar Charts
    • Automatic Chart Selection Feature
    • Chart Orientation / Rotation
    • Adding Deviation Charts
    • Changing Deviation Charts Types
    • Special Value Treatment
  • 🎨Formatting
    • Label Formatting
    • Scenarios
    • Themes
    • Colors
    • Conditional Formatting
  • 👩‍🎓Examples
    • 📈Profit and Loss Statement
    • IBCS Styled Bar Chart with Deviations
    • Quick Examples
      • Waterfalls in Columns
      • Products Stacked by Segments
      • Comparing Quarters
      • Comparing Measures
      • Delta Waterfall by Drill Down Combination
      • IBCS Bar Chart
  • 🔑Licenses
    • Trial License
    • Paid Licenses
    • Assign Paid Licenses
    • Free License
    • Publishing to the Web
  • ❕Additional Information
    • Data Security Overview
    • Change Log
Powered by GitBook
On this page

Was this helpful?

  1. Chart Types

Special Value Treatment

PreviousChanging Deviation Charts TypesNextLabel Formatting

Last updated 11 months ago

Was this helpful?

In certain scenarios, especially when creating income statements and similar financial reports, you might need to treat specific members differently to accurately reflect the data. The Special Value Treatment feature in Innofalls Charts provides various options to customize how individual members are displayed and calculated within your waterfall charts.

How to Apply Special Value Treatment

While in edit mode, click on a category label to access further options for that specific category or member. You will see three checkboxes that allow you to modify the treatment of the member:

  1. Increase is Good:

    • Default Setting: This option is checked by default, meaning increases in this category will be shown in green, indicating positive impact.

    • When Deselected: If you deselect this option, increases will be shown in red (negative impact), and decreases in green (positive impact). This is particularly useful for cost categories, where an increase typically represents a negative business outcome.

  2. Invert Value:

    • Default Setting: This option is unchecked by default.

    • When Selected: Selecting this option will invert all values associated with this member, including its child elements, ensuring a valid breakdown of the chart. This is useful when costs are entered as positive values but need to be displayed as negative for accurate representation.

  3. Skip:

    • Default Setting: This option is unchecked by default.

    • When Selected: This option will exclude the selected value from the waterfall chart calculations, effectively ignoring it in the breakdown.

Overview Window

Next to each checkbox, there is a link labeled "View all changed." Clicking this link opens a window that provides an overview of all members with special treatments applied. From this window, you can manage and remove these special treatments as needed.

Practical Example

Imagine you are working on an income statement and you have costs recorded as positive values. By using the "Invert Value" option, you can ensure these costs are displayed correctly as negative values, providing a more accurate representation of your financial data.

There is an option in the Properties Pane under "Formatting" that inverts all Red/Green colors, in case this applies to all data displayed.

📊
The options available after clicking 2020
Keep an overview of the special members