Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
is it possible to remove null values with alt function
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.
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