I need to create values of a certain field based on the values of another field in the same data set. I am trying to use the random function to generate a numerical value. However this ends up creating a dataset with a lot of blank values for that field
Here is the formula I am using :
if field('Type') == 'Road' then random(500000,5000000) else end
Not quite sure how to prevent creation of null values in the dataset.