Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Hi,
Try this num((LOSS_OVER_IM/sum(CBBC)),'#0%')
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
Please Attach your application.
I attached the application. Data is scrambled. Thanks
Any ideas?
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?
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?
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