sum (if..
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
How to get this output in Alteryx ?
- Labels:
- Help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Please provide more detail to describe the precise behavior you hope to replicate. An image with a massive Excel formula is not very clear.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@CoG
You are a nice person. 😁
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
sheet 3 column y is start date
sheet 3 column z is end date
sheet 1 column B is is manually dates (end Quarter dates )
how to do the same formula in alteryx, especially that I want to sum if (cumulative) conditioning on column B manually long dates list (end Quarter dates )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
That's a start but please describe your formula. You know what it does, but we don't, and I do not want to try to parse through a screenshot of a block of text, hoping that I understand it and risk providing you with misguided assistance, which wastes both of our time. Best Practice for question asking:
1. Include detailed description of problem, your inputs, desired output, and how the bits in between ought to work. Ideally, you will include what you have already tried to solve your problem
2. Sample data that includes real (not confidential of course) or dummy inputs and outputs that are representative of you problem in the form of a table or excel spreadsheet
3. (Optional but really great) A .yxmd or .yxzp with your current progress.
You can use the Summarize Tool to perform a sum calculation and you can preface that with the Formula Tool to capture conditional logic.
Hope this helps and Happy Solving!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Can you please share excel file.