Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have a table as attached. in the first column i have the months (Feb 2017, MArch 2017 etc) in the second column it comes up with Dec 2016 till date
can i get a simple solution to restrict the second column to display only from the value in column1.
for ex if the column1 displays Feb 2017, Column 2 should display Feb 2017, March 2017, April 2017 and not earlier than that.
kindly advice
Hello!
If column1 and column2 has a date format you can use this condition:
if(column2>=addmonths(column1,0) and column2<=addmonths(column1,2),column2,null()).
Remember that you already have a null value in column2 so you must modify it somehow, otherwise all rows that is not true for the condition above will be cumulate in the null-row.
Hope you find it usefull!
Hello!
If column1 and column2 has a date format you can use this condition:
if(column2>=addmonths(column1,0) and column2<=addmonths(column1,2),column2,null()).
Remember that you already have a null value in column2 so you must modify it somehow, otherwise all rows that is not true for the condition above will be cumulate in the null-row.
Hope you find it usefull!
Thanks Sergey , will try your suggestion