IF ITEM(Status1) = Status1.Test AND 'ModuleName1'.ColumnName1=Status2.Test2 THEN'ModuleName1'.Value[SUM: 'ModuleName1'.Type] ELSE 0
Can someone help me with the above formula, Is to ok to use an AND operation for the above calcualtion.
Hi,
Without knowing anything else about what you are doing, the formula looks fine. Using AND is common. if you need a second (stand-alone) condition, then use ELSE IF...
Note that the sum statement (SUM: 'ModuleName1'.Type) implies that the value you are summing by (i.e. Type) is a dimension of the result (which means that Type is a dimension of the Line Item* the formula is in).
*Note: Demension of the result technically refers to the dimensions of line item that the formula is in. In most cases, this will be the dimensions of the module as a whole, but the dimensions could be unique to the line item itself if the line item is a subsidiary view... that is, if the line item has different lists/dimensions than the related module).
Cheers!
Paul
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
Estimated Level of Effort:4-8 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L2 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased planning time Increased accuracy of targets/spreads You Might Also Like: * Historical Snapshotting Top-Down Allocations Whether it's…
