Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All. I have a table with several dimensions and billing category totals. One of the dimensions is Student ID. If possible, I'd like to exclude Student ID = 0 (zero). Student ID zero refers to "Non-Student" time (traveling, etc).
Thanks.
May be use this in your expression
{<[Student ID] -= {'0'}>}
Hi Sunny. Where would I place this expression?
Also, unrelated to this, I added a profile picture to my profile and it doesn't who on my name icon. Do you see my profile picture?
you add it in ur measure:
sum({<[Student ID] -= {'0'}>}YourMeasure)
to answer ur second question: u add ur photo as an AVATAR so that It can be seen when u comment
THank you Omar. StudentID is not a measure, it is a dimension.
You can do like this
If([Student ID] = 0, Null(), [Student ID])
Thank you Sunny, this worked! and I learned something useful !