user091100 Member

Comments

  • ok let me try to explain it this way i want one beast mode to show me only January entries, one beast mode to show me only February one for March excreta, so i will have 12 beast modes to have each of them as columns so we have a quick view of which locations have completed the drills each of those months the above worked…
  • MarkSnodgrass it did work but not the way i had hoped my fault not yours think i know what i need to do to get it work thank you so much everyone for your assistance
  • its not working i keep getting "invalid formula this calculation contained a syntax error i thought it might be the way the data is in the data set as it comes over as Jan 1, 2022 so i changed it to that but still getting the error (CASE when `Date` >= "Jan 1, 2022' AND `Date' <= 'Jan 31, 2022' Then 1 ELSE 0) and tried…
  • That is perfect Thank you worked beautifully