About jbrass

jbrass · ‎03-24-2021

is there anyway to reference the next or previous item in a list by using a formula? I saw a post a while ago that inferred that this was not possible without quite a bit of conversion logic. thanks, josh

jbrass · ‎03-23-2021

If you don't have "all Periods" in the time dimension, then you can use a TIMESUM formula with a blank "start period", which effectively sums all periods. The formula would be: TIMESUM(Module with time.Amount) = 0 The only problem with this is that it effectively takes the sum of all periods, so if you have a -$1000 in one period and then a +$1000 in another period, then it treats it like a blank. The overcome this, you could setup a 2nd line item in the module that includes time to dictate whether or not each cell has a value. Maybe call this line item "check if blank". So the formula would be: IF Amount <> 0 then 1 else 0. Then, point that TIMESUM formula to the "check if blank" line item instead (so it would be TIMESUM(Module with time.'check if blank')). Hope this helps! Josh

jbrass · ‎03-22-2021

Thank you @kevin.cho , this works perfectly. Thank you @rob_marshall and @Misbah for your help and commentary as well.

jbrass · ‎03-20-2021

Thanks Rob. That’s the approach I’ll take. Was trying to see if I could skip the import process (that we’d use to populate that email list), but it sounds like that’s not possible. Appreciate your help on this! Josh

jbrass · ‎03-19-2021

Thanks Rob. That makes sense. I was trying to see if there was a way to do it without having to run an import process (to create that list), but it sounds like this is the only way. Thanks again, Josh

jbrass · ‎03-18-2021

I can actually use email (which is a text field) instead of name to make it a tighter match. Understand that this may have holes, but this is just being used to flag potential issues so I'm not too concerned. Thanks, Josh

jbrass · ‎03-18-2021

Hello! I'm running into a problem that I'm struggling to solve and was hoping that I could get some help here. I have a numbered list that represents employees. Sometimes, employees are converted from part-time to full-time and when this happens, they are assigned a new employee ID. I need to be able to identify cases where there are multiple list items that represent the same individual (based on a text field that shows their name). In excel, this would be accomplished by using a countif formula. I'd like to know if there is a simple solution that I'm just not seeing. I think I could create a new list based on the concatenation of employee ID and name, and then have the name be a list property and then do a count based on that, but I'd like to know if there is a solution that requires less steps (preferably no need for a new list or import action). Screenshot below; The "Count of items" field is what I'd like to make formulaic. Thank you! Josh

jbrass · ‎03-11-2021

Hi @dsoomar002 Thank you for your quick reply. The goal is to show a rounded number throughout. If possible, I am trying to solve this without rounding the aggregated number (using formula as summary method). That $.01 (in this example) is problematic, as I'd like for this to be exported to excel and then for a user to be able to sum that data again and get the same end result. So, to answer #3 below, I do not expect for the rounded and unrounded numbers to be the same (in this case I want the rounded number to be 41.63 while the unrounded number is 41.62). My goal would be not to build a ton of additional logic to accommodate this. Given this context, can you provide more insight into your proposed solutions? For context, let's assume that the row set in question is a million rows (not the 4 row example that I screenshot). Thanks, Josh Thanks, Josh

jbrass · ‎03-11-2021

Hello, I'm having an issue in which a sum of rounded items is still showing some unexpected decimals. See screenshot below. Is there a workaround for this other than using formula as the summary method? Thanks, Josh

jbrass · ‎12-02-2020

Completely agree with this. I'm trying to find out what list format is being used for a specific line item and there is no way for me to know, as the list name is longer than what is visible in blueprint mode, and I'm in a deployed model so I can't double click into the cell to see it that way. Copying and pasting to excel doesn't show me the name of the list either.

jbrass · ‎06-25-2020

Agreed. I do not currently know of a way to restrict the user from un-hiding potentially sensitive information by simply showing columns. The only way that I know to protect such data from the end user is to create a separate module that does not include that data, and do a bunch of linking between modules which is a waste of time and workspace. Unless anyone has any ideas of how to accomplish this using existing functionality? Thanks, Josh

jbrass · ‎06-11-2020

Hello, I think it would be helpful to be able to set default options for the "Show New Content" selections in the Contents section of the settings panel. Currently it defaults to "On" for new functional areas. This can be problematic, and could accidentally provide roles with access to modules and dashboards that they should not have access to. If anything, I'd rather this default to "Off", so that the admin is required to provide access. I'm sure there are plenty of other items on the roadmap but figured I'd point this out in case it's a relatively quick fix. Thanks! Josh

jbrass · ‎01-17-2020

My extract has multiple lines per SFDC Opp ID, so I'd need to get a unique ID for that Opp ID/Product ID combination, and I'm working the SFDC guy in house to see if we can get that. Was working on this as a backup method in case we can't get that. Anyway, this works! Thanks for your prompt help!

jbrass · ‎01-17-2020

Update - figured out the rank function. Thanks so much! Rob - still open to discuss the approach.

jbrass · ‎01-17-2020

Thank you both. Still struggling with the RANK function a bit. The first input in the function is the source data, which has a requirement of being a number, date, or time period. What should I point this first parameter to? Rob - in regards to your question: I am trying to ingest a data source that does not include a unique ID. This is going to come as a manual file load (for now), and therefore there is no ETL layer that I can leverage to source a unique ID. I'm OK with manually populating a basic unique ID in the source file (by just including a "row()" formula in excel), but need a mechanism by which we can clear and reload portions of the data as needed. So, I need an ID that I'll be able to replicate next time I load the data, and have Anaplan know which items to replace vs. add to the list. I was going to use the example above to accomplish that. My example was obviously very much simplified, and the real example would actually be a concatenation of SFDC opportunity and product. Hope this makes sense, and open to feedback. Thanks, Josh

jbrass · ‎01-17-2020

Hi All, I was hoping to get some with a problem that I'm trying to solve. I have a module with a line item that is list formatted. In this module, the 'applies to' is a list that has 7 values. The line item in the module has the following items shown for each of the 7 rows: item 1: Product A item 2: Product B item 3: Product B item 4: Product C item 5: Product C item 6: Product C item 7: Product D I'm trying to identify items that are shown more than once and create an additional snippet of text at the end to effectively make each item completely unique. The output I'd like to see is: item 1: Product A_1 item 2: Product B_1 item 3: Product B_2 item 4: Product C_1 item 5: Product C_2 item 6: Product C_3 item 7: Product D_1 NOTE: I do not want to set this up with a series of isfirstoccurrence logic that would require for me to setup a bunch of line items to accommodate any number of duplicate results. This logic needs to work with any number of duplicate results. Can anyone solve this for me?! Thank you!

jbrass · ‎10-31-2019

Hello, I constantly run into the same issue and I'm hoping that someone can help suggest a solution. When I create an action that imports from a csv file into a list or module, I always find it difficult to re-open up that import action and revise (or just view) the mapping that was previously created. Instead, I have to do this funky workaround where I re-import a file that has the same name as the file that was previously loaded only for the purpose of viewing the mappings. This seems silly to me; hoping someone has a better solution. Thanks! Josh

jbrass · ‎10-01-2019

Hello all! In the modules screen within settings, you can view whether a given module is shown on a dashboard AND which other modules reference that module. This gives a great indication whether or not that module is active OR whether it is a candidate for getting deleted. What is NOT shown, however, is if a given module is referred to within a filter of another module. I'd like to see that added as a column within the modules screen. Furthermore, would be great to be able to tell if that module is used as either the target or source of an action. If none of the above were the case, could Anaplan almost suggest that this is an unused module and therefore should be heavily considered for deletion? Of course, if you have users that open modules directly and view data from them, then you could have the risk of that view just going away, however I always make all users go through dashboards instead so this wouldn't be a risk for me. Thoughts? Thanks!! Josh

jbrass · ‎06-27-2019

Thanks Rob, that is helpful, and I somehow never noticed that feature before. This doesn't exactly solve what I need though. I have an L1 list and an L2 list. If L1 was customer and L2 was product, then I'm looking to export the data related to the 1st L1 item to excel, and then have the same happen in the 2nd tab but for the 2nd L1 item. Basically, if I have a dashboard which syncs on the L1, but shows both the L1 and L2 levels, then I'm looking for an excel tab that mimics what happens every time I select a new L1 item. Does that make sense? Thanks, Josh

jbrass · ‎06-27-2019

I'd looking for something that I think I've seen in other systems referred to as "explode" functionality, which would effectively create a new excel tab for every list item and export to that tab. So, if I have a department list (for example), I'd like to export data to excel and have a tab show up with the data for each of the departments. This isn't the exact example I'm looking for (in fact, the example I'm looking for has about 100 items in the list), but this should give you a sense of what I'm looking for. Thanks, Josh

jbrass · ‎06-10-2019

Hi David, The example below was just an example; not the exact use-case I'm looking for. I'm looking for a smooth way to create a list of the concatenation of 2 line items in a module that has 2 different lists in the applies-to. For example, if you had a module with an Acct List and a Cost Center List, and then you have an "Amount" column. If you were trying to create a saved view that just isolated the code of the Acct List with the code of the Cost Center list for items with Amount <> 0, and then publish those concatenated items to its own list. That's effectively what I'm trying to do. Thanks! Josh

jbrass · ‎06-06-2019

Thanks Leonardo and Rob for your responses. I'm not sure that the answer given achieves the result that I'm looking for. Please see screenshots below as an example. The first screenshot shows an example of what I'm trying to do. If you have 2 lists in the applies to (for example cost center and GL account), I'm trying to do a FirstOccurrence on the concatenation of the codes of those list items (see the "P&L/CC Combo Text" line item). Note that below, I've included "time" in the module, so the result should show a check box under the first item shown, and not the 3 items thereafter (since the concatenated item was already shown). I've tried using just 1 of the lists in the end of the isfirstoccurrence formula, but that doesn't seem to work (see columns 2 and 3). Hope this makes sense. Please let me know if you need more info. Thanks! Josh Brass Thanks, Josh

jbrass · ‎06-04-2019

Hello, Does anyone know if it's possible to do a firstoccurrence formula on a module with 2 lists in the 'applies to'? Thanks! Josh Brass

jbrass · ‎04-02-2019

Fair enough, thanks!

jbrass · ‎04-02-2019

Hi All, I could swear that I've seen some dashboards created that include a fancy green check mark or a red "X". How do I get those to show in a module or dashboard? Also would be good to see which special characters work in Anaplan (such as the triangle delta sign). Thanks! Josh Josh Brass Brass Planning Solutions, Inc.

jbrass · ‎01-03-2019

Hello, I'm trying to import a date into a text-formatted property from a source file. This works on my machine, however when another user uploads the same file, it seems to be creating a text field which includes 2 digits for the year vs. 4. So, when I run the import, the text-formatted field reads "12/31/2018", but when someone else runs the same file, it reads "12/31/18". Does anyone know why this is happening? I've had the user send me the source file that they are using, and it still shows with the 4 digit date on my machine, but 2 digits when he uploads that file. Since I'm using this property as part of a "combination of properties" to create a unique ID, this is a very important item. Thoughts? Thanks, Josh