Formula related issues
I have two issues as descried below. Please can you help me on it.
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|
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.
Please can you help me on the below two issues.
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
Hi @Rajasekhar ,
Thank you so much.0