- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ADDED COLUMN DOES NOT CALCULATED CORRECTLY
Hello, this is in Power Query environment:
I have period 12 and 9, trying to see the difference by adding a cusomer column = 12-9
but not all rows are correctly calculated the difference.. not sure why?
thank you for your input
Zoey
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
thank you.. it seems only where the value is null, it does not work. that is why I replace null with 0
thank you
Zoey
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
thank you list.sum works! but why a straight forward col12-col9 does not work though? I will research on this further.
thank you
Zoey
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
that is a good read,
thank you
Zoey
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you try to change your column names so they do not start with a number?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
thank you it does not work, but AlienSX suggested to use list.sum, it works.
Thank you for your time.
Zoey
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Show the code for "Added Custom"

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
03-26-2024 04:18 AM | |||
08-18-2024 09:59 PM | |||
07-03-2024 01:57 AM | |||
08-05-2024 11:08 PM | |||
08-22-2024 02:34 AM |