Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be like this
If(Len(Trim([Contract ID])) > 0 and [Contract ID] > 0, Sum(TOTAL <#, Name>Revenue))
May be like this
If(Len(Trim([Contract ID])) > 0 and [Contract ID] > 0, Sum(TOTAL <#, Name>Revenue))
Can you share the sample source data?
Hi stefan
Do want fill null contract_ID with 33
and
Sum the Revenue of null contract_ID with 245324?
Thanks a lot Sunny.
This seems to be doing the job
Stefan