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

Answers