I have a report that shows a daily log. There are 3 fields for AM, Midday, and PM. I am trying to see if there is a row level formula I could use to count how many of those 3 fields do NOT contain "Not Logged".
1 件の回答
For that you could use a Formula field or a Row-Level Report formula like this
CASE( Field_A , 'Not Logged',0, 1 ) +
CASE( Field_B , 'Not Logged',0, 1 ) +
CASE( Field_C , 'Not Logged',0, 1 )
