topic Re: Providing AND operation in calculating a line item. in Anaplan Platform
https://community.anaplan.com/t5/Anaplan-Platform/Providing-AND-operation-in-calculating-a-line-item/m-p/33843#M951
<P>Hi, </P><P> </P><P>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...</P><P> </P><P>Note that the sum statement (<SPAN>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).</SPAN></P><P> </P><P><SPAN>*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).</SPAN></P><P> </P><P><SPAN>Cheers!</SPAN></P><P> </P><P><SPAN>Paul</SPAN></P>Thu, 14 Jun 2018 12:22:34 GMTPaulRitner2018-06-14T12:22:34ZProviding AND operation in calculating a line item.
https://community.anaplan.com/t5/Anaplan-Platform/Providing-AND-operation-in-calculating-a-line-item/m-p/33838#M949
<P>IF ITEM(Status1) = Status1.Test AND 'ModuleName1'.ColumnName1=Status2.Test2 THEN<BR />'ModuleName1'.Value[SUM: 'ModuleName1'.Type] ELSE 0</P>
<P> </P>
<P>Can someone help me with the above formula, Is to ok to use an AND operation for the above calcualtion.</P>Mon, 22 Oct 2018 21:34:56 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Providing-AND-operation-in-calculating-a-line-item/m-p/33838#M949anees2018-10-22T21:34:56ZRe: Providing AND operation in calculating a line item.
https://community.anaplan.com/t5/Anaplan-Platform/Providing-AND-operation-in-calculating-a-line-item/m-p/33841#M950
Is there a way where I can include the second condition for calculating the value.?Wed, 13 Jun 2018 15:08:48 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Providing-AND-operation-in-calculating-a-line-item/m-p/33841#M950anees2018-06-13T15:08:48ZRe: Providing AND operation in calculating a line item.
https://community.anaplan.com/t5/Anaplan-Platform/Providing-AND-operation-in-calculating-a-line-item/m-p/33843#M951
<P>Hi, </P><P> </P><P>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...</P><P> </P><P>Note that the sum statement (<SPAN>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).</SPAN></P><P> </P><P><SPAN>*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).</SPAN></P><P> </P><P><SPAN>Cheers!</SPAN></P><P> </P><P><SPAN>Paul</SPAN></P>Thu, 14 Jun 2018 12:22:34 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Providing-AND-operation-in-calculating-a-line-item/m-p/33843#M951PaulRitner2018-06-14T12:22:34Z