i have a fact table ?

[#1]

i want cross check my fact table ,how many null values and distinct values are there

i have only fact table ,how to check?

[jpapador]

For the distinct values you can go to the top menu bar Settings > Document Properties > Tables Tab.

Click on your table and it will tell you the numbers of values and distinct values.

[maxgro]

in a field?

nullcount(fieldname)

count (distinct fieldname)