Slice creation issue

Dear Team,

I have the data mentioned below. I want to create slices likes students and comments but excluding the default comment โ€œNilโ€

3X_9_9_99fb944384cd8c860a5a9c4a7290a7c2c8a1991d.png

0 5 241
5 REPLIES 5

If I understood your request, you could use a condition rule like NOT([Complaints]=โ€œNilโ€)

Thank you.

if it blank instead of nil what will be the formula

OR(
ISNOTBLANK([Complaints]),
NOT([Complaints]=โ€œNilโ€)
)

thank you!!! @Aleksi

Youโ€™re welcome

Top Labels in this Space