Solved! Go to Solution.
In order to accomplish the same as a SUM IF, you would need to complete each of the portions of a SUM IF in Alteryx. I would recommend using a filter tool before the summarize tool to accomplish that. In the filter tool you could create a custom filter and write an IF statement that would say 'if [category] = "1st option" then "1st option rule"' you would finish this statement for each rule you are looking to execute. Once you do that connect a summarize tool to the True output of the filter tool and then you could sum what is needed. This should create the same functionality as a SUM IF in excel.
hi @Kim2
Are you able to show a mock-up excel of the desired outputs from a mock-up input?
Cannot follow the question 100%.
Dawn.
hi Kim,
I am guessing... did you try to drag a file into the "Post reply" window? That does not work, unfortunately. At least for myself, initially i did not know how to attach a file....
In case you are in my previous shoe (and please pardon me if i'm saying something that you already know): You need to click on the Reply button (see below) and then click on "browse" to attached.
hi @Kim2
You are trying to run the accounting depreciation expenses for different categories of fixed assets right? Just to confirm that I understand the nature of the requests right.
the reason I asked is because there are 2 columns in tab "Rules" that can be used to calculate the depreciation. Which column "Useful life" or "Rule" should be use to determine the depreciation period?
Also, some rules don't make sense. E.g. INTERNAL DEV 5 YEARS have "Useful life" = 5 and "Rule" = 10.
If you can clarify I may be able to find sometime to help you (no promise though...)
Dawn.
Hi,
So basically I am trying to calculate our future asset retirements. So on the rules tab under FY23, FY24 & FY25 those are the years that the assets are tagged to will need to be retired. So for example looking at Computer HW 3 YR in FY23 we want to see what assets were tagged to Computer HW 3 YR in 2016 and those assets would be our estimated retirements in FY23. So looking at the data tab in row 36 we can see computer HW 3 YR in 2016 was $1,549,419.48 which is what I would need to be returned on my output tab under Comp HW 3 YR under FY23.
Thanks,
Kim
hi @Kim2
So basically columns B and C are irrelevant.
Take Comp Hardware 3 Yrs. The rule is that if it was purchased in 2016 then it should be retired in FY23, if purchased in 2017 then should be retired in FY24.
Is that right?
Hi,
Yes that is correct!
Thanks,
Kim