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 have 80 ADO source datasets currently sourced from our DEV Anaplan model, with 80 transformation views, 20 consolidated transformation views, and 20 Snowflake outbound pipelines. When we move to PROD, is there a supported way to repoint the existing Anaplan source datasets from DEV to the equivalent PROD model while…
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.…
