Scatter Chart

[#1]

I have 3 regions and related data in the attached QVW.In 1 exp I have Cost/Rsf and in other I have Cost/Csf...but since one of the expressions on NOAM and LATAM has 0 I only see ASIA.Where as I want to show 0 as well.

Ex: I want NOAM TO show Cost/Csf : 0 and Cost/HC = $40 ?

How can I do that ?

[clondono · Accepted solution]

How about for your two expressions:

Cost/RSF

=If (CSF=0, 0,SUM(Cost)/SUM(CSF))

Cost/FTE

=If (HC =0, 0,sum(Cost)/sum(HC))

Regards,

Carlos

[settu_periasamy]

May be like attached?

[#4]

Ya...Thank you but what did you dIfferently... ?

[settu_periasamy]

I didn't do anything differently. When the value divided by 0, it gives Null value or Missing value (Means '-' hyphen)

so, just i used rangesum(field1/Field2) -> this gives 0 instead of Null.

Let's know, is this your need or something else?