About neg177

neg177 · ‎06-09-2021

Hi, I'm trying to write a formula in a module that is time dimensioned as Daily, but the module I'm pulling the data from is monthly. How can I get data to come in. Basically I'm trying to break down the monthly information into daily. I do not believe a subsidiary view will work. Thank you

neg177 · ‎06-08-2021

Thank you. Very helpful and we got the formula we needed.

neg177 · ‎06-07-2021

Hi, Need help creating a formula that will divide a child in a list by the parent. screen shot of the formula I have Looking to take the Amt from both Direct & ISO and divide them by the All BU parent from another module in their specific columns.

neg177 · ‎06-07-2021

Hi, Trying to look up a Line Item Subset to use in a formula. Example of the formula is as follows. IF ITEM ( LISS C67 Commissions ) = 'LISS C67 Commissions'.'52053 - Internal DS rep commission' THEN 'R18 Lending Summary'.$ Funded/'R18 Lending Summary'.'Total Cash Collections*' ELSE 0 Formula is not going through because using a LISS.

neg177 · ‎05-24-2021

Hi, Still having a problem getting around this circular reference. The formula I'm using is below. The Opening Balance Line Item is causing the circular reference because it is being called upon twice. Formula For Line Item that is saying Circular Reference IF 'S01 Time Settings'.'10th of every Month?' THEN Borrowing Base Adjustment [ LOOKUP: 'S01 Time Settings'.Last day of Previous Month ] + Cash Collected [ LOOKUP: 'S01 Time Settings'.Last day of Previous Month ] + '(Cash Sweep to Wells)' [ LOOKUP: 'S01 Time Settings'.Last day of Previous Month ] + 'BALANCING FIGURE FOR x5000' [ LOOKUP: 'S01 Time Settings'.Last day of Previous Month ] + 'Securitization Master Acct (x5000 Opening)' [ LOOKUP: 'S01 Time Settings'.Last day of Previous Month ] ELSE 0 Formula that is also calling the Opening Balance Borrowing Base Adjustment + Cash Collected + '(Cash Sweep to Wells)' + 'BALANCING FIGURE FOR x5000' + 'Securitization Master Acct (x5000 Opening)' + Excess Funding Sweep If you need more explanation I can try and be more specific. Thank you

neg177 · ‎05-20-2021

Hi, Having a problem avoiding a circular reference when it comes to this Anaplan Formula. The circular refence comes up in the Line Item's "Excess Funding Sweep" when trying to make equal to the "Calculated MCA Sweep to Excess Funding", because the "Calculated MCA Sweep to Excess Funding" references the "Securitization Master Account Closing" Line Item, which is a sum that includes the "Excess Funding Sweep" Line Item. Please advise on how to avoid the circular reference, Thank you

neg177 · ‎05-05-2021

Hi, Need help replicating this Excel Formula. The Anaplan formula we created is not working. Excel Formula =IF((WR20+WR26+WR27+WR29+WR28+WR5*0.95+WR31+WR32+WR35)-WR40>0,IF(WR29+(WR5*0.95)+WR31+WR32+WR28-WR35<0,0,WR5*0.95),0) Our Formula IF 'S01 Time Settings'.Actual Date <= 'S02 Time Admin'.Last Actual Day THEN PFR Value of Receivables * 0.95 ELSE if (Total Eligible Principal + 'Interest Acct (x1001)' + 'Securitization Master Acct (x5000 Opening)' + 'BALANCING FIGURE FOR x5000' + PFR Value of Receivables * 0.95 + Cash Collected + '(Cash Sweep to Wells)') - 'Min. Asset Requirement'>0 then if ( IF 'S01 Time Settings'.Weekdays? THEN IF WEEKDAY(START()) = 1 THEN OFFSET('Securitization Master Acct (x5000 Closing)' , -3, 0) ELSE PREVIOUS('Securitization Master Acct (x5000 Closing)' ) ELSE 0)+(PFR Value of Receivables*0.95) +Cash Collected+'(Cash Sweep to Wells)' +'BALANCING FIGURE FOR x5000'-Excess Funding Sweep<0 then 0 else PFR Value of Receivables*0.95 else 0

neg177 · ‎05-05-2021

Hi, Yes that is correct

neg177 · ‎05-05-2021

Hi, Yes the pic of the module and formula are below. Thank you The Excel Formula =IF(AND(Accounts!WU32<3000000,MIN(4000000,WU27,WU41-2000000)>0),MIN(4000000,WU27,WU41-2000000),0)

neg177 · ‎04-29-2021

Hi, I'm trying to replicate the Excel Formula in Anaplan below. I'm trying to use the AND function, so i made two Boolean Line Items and combined them to satisfy the condition. The formula worked but no numbers are showing in my line item. please advise. Excel Formula =IF(AND(Accounts!WP32<3000000,MIN(4000000,WP27,WP41-2000000)>0),MIN(4000000,WP27,WP41-2000000),0) My Formula IF 'EFS to WFA Calc1' AND 'EFS to WFA Calc 2' THEN MIN ( 4000000 , IF 'S01 Time Settings'.Weekdays? THEN IF WEEKDAY ( START ( ) ) = 1 THEN OFFSET ( 'Y03 Securitization (Actuals)'.'Excess Funding Account (x1005)' , - 3 , 0 ) ELSE PREVIOUS ( 'Y03 Securitization (Actuals)'.'Excess Funding Account (x1005)' ) ELSE 0 , ( IF 'S01 Time Settings'.Weekdays? THEN IF WEEKDAY ( START ( ) ) = 1 THEN OFFSET ( 'Y03 Securitization (Actuals)'.'Excess Collateral / (Deficit)' , - 3 , 0 ) ELSE PREVIOUS ( 'Y03 Securitization (Actuals)'.'Excess Collateral / (Deficit)' ) ELSE 0 ) - 2000000 ) ELSE 0

neg177 · ‎04-23-2021

Hi, We need help trying to write a formula for a value to show on only every 10th of a given month. Also need to consider that the weekends do not count and would fall into the next business day. For example 4/10/2021 is Saturday so would pick up 4/12/2021 instead.

neg177 · ‎04-23-2021

ok, Thank you

neg177 · ‎04-23-2021

Hi, We are trying to pick up a Line Item Balance from the previous end of the month. For example, for the month of Feb, need to see the ending balance that is at the end of January.

neg177 · ‎04-23-2021

Hi, Thank you it worked out great.

neg177 · ‎04-21-2021

neg177 · ‎04-21-2021

Yes, we are using the Moving sum, but not getting back the correct average, I believe because it is picking up weekends (which we don't want it to do). This is the current formula we are using... MOVINGSUM('Y03 Securitization (Actuals)'.Portfolio Factor Rate, -5, 0, AVERAGE) we are trying to pick up the previous M, T, W, Th, F

neg177 · ‎04-21-2021

Hi, Need help creating a formula that pick's up the moving average for a number within 6 business days. Example) The amount for a line item over the past Weekdays were 1, 4, 6, 8, 9. I want to forecast this by finding the average of those days. Thank you

neg177 · ‎04-21-2021

Thank you for your help. we figured it out.

neg177 · ‎04-16-2021

Hi, I'm trying to create a line item in the target module that pulls in the values from the source module given a certain day. Attached are screen shots of the modules. Please advise. Target Module Source Module Thank you

neg177 · ‎04-09-2021

we are using regular time.

neg177 · ‎04-09-2021

I'm not sure what you mean by Native Time?

neg177 · ‎04-09-2021

neg177 · ‎04-09-2021

attached is the mapping tab on the action we are trying to perform. Thank you

neg177 · ‎04-09-2021

attached is a pic of the data in one of the cells. Also to eliminate that delimiter issue should we import it as a txt verses a csv?

neg177 · ‎04-09-2021

Yes, attached is the snap shot of the Excel File.

neg177 · ‎04-09-2021

We changed the dates to be formatted to match Anaplan. Shown in the Snap Shot below. We also tried other formats and still not automatically mapping the dates.

neg177 · ‎04-09-2021

Hi Rob, I'm not sure why the dates are separated with the "-", We tried to export data from Anaplan to add additional data in Excel, and when we tried to import the csv file back into Anaplan we saw that the dates then had the separation. Leading to the manual mapping.

neg177 · ‎04-09-2021

Hi, I would like to know how to match my flat file's when my dates on my flat file and Anaplan do not match. Usually I end up having to manually match them. Please advise. snap shot attached below. Thank you

neg177 · ‎03-25-2021

Hi, I'm trying to create a formula that will pull values in accordance to each weekday. Below is the Formula I'm currently using. I have screen shots of the Modules I'm pulling from as well. If you need more information on the topic please let me know. 'D01 Funding Ratios'.Average of Fund * '01S03 Weekday count by month'.Monday Dayification'.Daily Funding * ' Thank you

neg177 · ‎03-24-2021

Hi, I would like to know what is the best approach for building when you have repeated Line Item's. How should you Dimension your Module? Attached is a screen shot of what I'm trying to replicate in Anaplan. Thank you