Calculating Null values

[pipuindia99]

Hi,

I have a table which contains values in dimension fields as ' - ' and it has values against it like $234 , $567... i want to add these values with other fields

would appreciate if anyone can help me with the expression.

[sunny_talwar]

Which other fields you want to add it to?

[pipuindia99 · Accepted solution]

Thanks Sunny,

I got the solution, appreciate your quick response.

[makrishnaraj]

Hi

You have to create an another dimension by specifying some text (Null) to the blank and than you can write the expression based on this dimension.

[sunny_talwar]

No problem... I am glad you were able to figure it out. Please close this thread by marking Assumed Answer now.

Best,

Sunny

[susovan]

Hi prabhu,

You can try this,

Sum({<Dimension=>}SalesAmount)