Overwriting blank fields in dimension

[Anonymous]

Hi All

I have this problem with irregularities in my data, which I'm not able to fix right now.

Therefore I'm trying to make a quick-fix instead.

If a customer has a contract # all the revenue should be registered on that contract #. However, this is not always the case due to human errors.

Would there be any solution where I could overwrite below, and group the revenue on the Contract # 33?

I would prefer to do this in the expression in the front end solution, and not in the script.

I'll appreciate all the help I can get.

Stefan

[sunny_talwar · Accepted solution]

May be like this

If(Len(Trim([Contract ID])) > 0 and [Contract ID] > 0, Sum(TOTAL <#, Name>Revenue))

[Anonymous]

Can you share the sample source data?

[Anonymous]

Hi stefan

Do want fill null contract_ID with 33

and

Sum the Revenue of null contract_ID  with 245324?

[Anonymous]

Thanks a lot Sunny.

This seems to be doing the job

Stefan