I have query regarding calculated field for the below scenario..
I have data for crash count of different products for past few months.
My query is tat I want to have a calculated field which checks for..
if (i have data for current month) AND (whether my Today's date is >15)
then (show data for current month)'
else (show data for whatever latest month data available)
Refer attached file for data
Retrieving data ...