Adding Two fields with one of them is Null

[sindhura]

I have two fields Tax and Credit.

Credit = Tax + Original Price.

But for some of fields, I have Tax fields as Null.

so I should get Credit =  Original Price.

but i see Null in the report for this field as well.

I have used the expression Tax + Original Price

Calculated dimension is also giving me the same result : Num (([Tax]+[Original Price]), '#,##0.00')

Can anyone please help me

[Peter_Cammaert]

Use RangeSum(Tax, [Original Price])

RangeSum will add individual values and treat NULL values as 0.

Best,

Peter

[sunny_talwar · Accepted solution]

Although Peter's solution is the best possible, but just for a sake of an alternative you can also do this:

Alt(Tax, 0) + Alt([Original Price], 0)

[jagan]

Hi,

While loading your data in script try to handle this using Alt() or Len(Trim()) like below, handling this in Front end is not a good idea.

Data:

LOAD

*,

Alt(Tax, 0) AS Tax_New

FROM DataSource;

OR

Data:

LOAD

*,

If(Len(Trim(Tax)) = 0, 0, Tax) AS Tax_New

FROM DataSource;

Now use Tax_New in the charts.

Hope this helps you.

Regards,

Jagan.

[sindhura]

All the scenarios worked.

Thanks a lot

[jagan]

Hi,

If you got the answer please close this thread by giving correct Answer to the post which helps you.

Regards,

Jagan.