Forums

einas.ibrahim

Hello everyone, @Misbah @Jared Dolich @rob_marshall If you know there is an issue with using POST with IF then please let us know, if you don't please read on. Context: We would like to move a value from the current period in a line item to another line item x periods ahead under a certain condition. IF Condition is satisfied THEN POST(Source, x) ELSE 99 If we don't use the condition, the POST function produces the results as expected (see below) If we add the IF condition based on the condition line item, POST doesn't perform as expected. It doesn't "move" the Source Value and the formula resolves to 0 in the same period (see below) As a side note, I tried to use a numeric condition and the results were the same. Finally, when I hard code TRUE as the condition, the POST function works (see below) Does anyone have an explanation for this behavior? even if the explanation is this is a bug. Thanks

Jsdeloria21

Hi Guys, I would like to ask help on this issue that I have never encountered before. In the clients excel sheet they are using a SUMPRODUCT formula. The Logic is multiplying the Start of the month (which is the starting month for their calculation) to the End of the month of the calculation engine but backwards. Let me demonstrate the action: Below is the 1st line item (which is a list) with values from Jan 16-Dec 16. 2nd Line item (which consists of the same list as above) has percentage but the value starts at the Month of Dec 16 backwards. Also, there is a line above labeled Month Spread. This is sort of their tagging per month on what month is the 1st month to start their calculation backwards. Base on their formula, the multiply the Value 1.Jan 16(which is 2) to the Payment Scheme 1.Dec 16 and so on. See below as you can see in the table above, Value 1(Jan 16) * Payment Scheme 1 (Dec 16) for the month of Jan 16, Value 1(Feb 16)*Payment Scheme 1(Nov 16)+ the value in JAN 16 and so on. Hope you can understand the illustration that I showed you since I cannot really post the actual report for you. Appreciate the help here. Regards,

MadhabikaM

Hi All, I have two dimensions, Employee and Activity. and this two are to be used a dimension in my Final module, I want to include a condition when a particular employee is selected from dimension drop down then only the relevant activity(this mapping is available in Activity List) should be visible in the Activity drop down. I know this is possible by dependent drop down for when my Employee and Activity both are line items in a module. but in this case, I have both as dimension(list)and I want in my module the dimension lists to dynamically update when the Employee is selected. Thanks Madhu

CommunityMember128217

HI all, I am loading data from excel to List and i have blank entries in the excel sheet which has business meaning, hence i am bit struggling to maintain blank entries in the list or how Anaplan recognizes the blank entries from excel records and loads automatically to the list. -Santosh

MohitVerman

test

Forums

Explore the Anaplan Forums

Category Activity

Known Issues with using POST and IF??

SUMProduct in Excel

Dependent List(dimension) selection

Data import from excel to List

How to add content

Community Leaderboard