asked 13 hours ago
This is regarding one of the issue which we are facing while generating report
We have column A , B and C value for this column contains data of type numeric
We have another column named "Date Reported" with the data type "date", we are applying some formula to calculate the value of column A, B and C. For the formula we need the value (like below) selected from Column named "Date Reported"
Since user can apply filter on the "Date Reported" , example filter selected is "Current : Month" then I want to get the number of days in the current month. Example 30days or 31days.
Similarly if user is selecting the filter with "Current : week" then value I am expecting is 7days.
These value shall be used in the formula for generating value in column A,B and C.
Please guide us with examples how it can be achieved.
