Formula related issues

Rajasekhar

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-20	Feb-20	Mar-20	Apr-20	May-20	Jun-20	etc till 2022
Line item A	0	0	0	10	0
Line Item B	TO 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	Data	New Country	Check
Russia	200	France	TRUE
Egypt	300
France	0		TRUE

 

Please can you help me on the below two issues.

 

Regards,

Rajasekhar

Misbah

@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

prabhu

 

Hi @Rajasekhar ,

 

PROBLEM 1:

 

 

 

 

 

 

 

Thanks,

prabhu

Hi @Rajasekhar,

 

PROBLEM 2:

 

 

 

 

 

 

Thanks,

Rajasekhar

Thank you so much.