alt fun?

[Anonymous]

alt(01/01/2015,01-01-2015,01-01/2015)   it returns correct date as for my understanding

but i want know what is the use of alt function when u go for this

give me small example

Null values can be removed using alt fun?

[alexandros17 · Accepted solution]

The alt function returns the first of the parameters that has a valid number representation. (as dates do). If no such match is found, the last parameter will be returned

[Anonymous]

is it possible to remove null values with alt function

[kuba_michalik]

Only if you are testing numeric values for being non-null. It won't work for text.

You can use IsNull() to test for nulls and combine with If() to remove them if needed.

[alexandros17]

I think it is not the better way to remove null values ...

If you want

to remove from the script (in a load or select) put a where condition (Ex. Where not IsNull(myField)),
if the field is a dimension, there is a check box to delte null values in the tab dimension.

Let me know