This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.

Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Incorta Community
- Discussions
- Dashboards & Analytics Discussions
- Calculate difference between values from three col...

Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

Options

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

05-30-2023 09:59 PM

Hi,

I need to calculate the difference amongst values present in three columns.

It needs to look something like this:

A | B | C | Difference |

10 | 10 | 10 | 0 |

10 | 10 | 9 | 1 |

10 | 0 | 0 | 10 |

10 | 9 | 10 | 1 |

Can someone guide me to formula or function that can help me acheive this result ?

Solved! Go to Solution.

7 REPLIES 7

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

05-31-2023 02:11 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

05-31-2023 04:05 AM

the calculation goes like this:

row 1 : 10 - 10 - 10 (all the three are same) = 0

row 3 : 10 - 0 - 0 (10 is the remaining value) = 10

row 4: 10 - 9 (since two values are same i.e 10, it needs to take the difference from the value that is different)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

05-31-2023 07:18 AM

You want to subtract distinct values where the distinct values are ordered desc ?

Offhand I'm thinking "Incorta over Incorta" ( i.e. use a result set as your insight data source ) where you get your three values and order them accordingly.

-- IncortaOne@PMsquare.com --

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

05-31-2023 09:59 PM

Hi RADSr,

Thank you for your response.

The order need not be asending or descending in this case, because we're trying to determine if the values match in all three columns, if it does not, it needs to show by how much are the values different.

Related Content

- How to calculate MAX value for each Row? in Dashboards & Analytics Discussions
- Filter by Date on three different date column in Dashboards & Analytics Discussions
- Comparing values between 2 columns from 2 different tables in Dashboards & Analytics Discussions
- Need to Calculate Difference of Date/Times of Same Column in Dashboards & Analytics Discussions