Calculating an expression - error

[#1]

Hi,

Table should look like this:

Date	No	Loss	%
12/02/2013	652	-152352	=LOSS/sum(CBBC)

CBBC field is loaded from a database.

Loss and %  are expressions and other fields are dimensions. At the moment, all the data is displayed fine apart from the calculated field where (–) is displayed rather than percentage. In the example above it should show a percentage, something like 3.05% for example.

How do I display the result for % field?

Hope this makes sense.

[#2]

Hi,

Try this num((LOSS_OVER_IM/sum(CBBC)),'#0%')

[#3]

Tried them both and still nothing... Only - displayed.

Loss  field is min(loss)

If i create a text object showing the calculation min(loss)/sum(CBBC), then it shows a result. If it's loss/sum(CBBC), then only - shows up.

However when I put min(loss)/sum(CBBC) in the actual straight table, nothing shows up

[#4]

Please Attach your application.

[#5]

I attached the application. Data is scrambled. Thanks

[#6]

Any ideas?

[#7]

Thanks.

If I choose a different scenario, then it's not displayed again. I need to display the biggest loss for a selected scenario.

Could you also explain how does TOTAL work?

[#8]

CBBC would be the same value for all the scenarios though.

Is it possible to set it so that if I choose another scenario with a different loss data, it would be divided by the same sum(CBBC) value? Somehow to 'unlink' CBBC from Scenario No so that it would not be affected if i choose a different one?

[#9 · Accepted solution]

I used set analysis and I think it gives me the right result:

fabs((LOSS)/sum({1<SC_NO=>}total CBBC))

Thanks for the help, really appreciate it