Formula related issues

Highlighted
Occasional Contributor

Formula related issues

Hi,

 

I have two issues as descried below. Please can you help me on it.

 

Problem 1:

I have a line item A having some data and Time scale for 4 years (in months). I want a formula on the line item B which can check if all time periods for line item A have only the value 0 and no other data. Please can you let me know if there is a function or formula for this.

 Jan-20Feb-20Mar-20Apr-20May-20Jun-20etc till 2022
Line item A000100   
Line Item BTO CHECK OF WHOLE OF A HAS ONLY 0 VALUES AND NO DATA  
         

Problem 2:

I have a module with the below line items Data, New Country and Check. Country is a list on the Rows.

I want to write a formula for CHECK such that it marks as TRUE if there is data for the rows having value in new country(here Row 1) and also for the Row which is equal to the New country value(here France--Row 3) irrespective of the data.

Country DataNew CountryCheck
Russia200FranceTRUE
Egypt300  
France0 TRUE

 

Please can you help me on the below two issues.

 

Regards,

Rajasekhar

4 REPLIES 4
Highlighted
Master Anaplanner/Community Boss

Re: Formula related issues

@Rajasekhar 

 

Problem 1: Do you mean to say that you want to display months that have Zero in it. In that case 

Formula in Line item B should be Line item A = 0( Boolean Format) and then apply the filter on Line A

 

Problem 2: Formula should be  FINDITEM(Country List, Text of New Country)

 

Hope that helps

Misbah

Highlighted
Super Contributor

Re: Formula related issues

 

Hi @Rajasekhar ,

 

PROBLEM 1:

 

1.JPG

 

 

2.JPG

 

 

3.JPG

 

 

Thanks,

Sorna Raja Prabhu
Highlighted
Super Contributor

Re: Formula related issues

Hi @Rajasekhar,

 

PROBLEM 2:

 

4.JPG

 

 

 

5.JPG

 

 

Thanks,

Sorna Raja Prabhu
Highlighted
Occasional Contributor

Re: Formula related issues

Thank you so much.