Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculated Expression Error

Hi,

% of DF is a calculated expression but it does not work. It contains the following:

=LOSS_OVER_IM/sum(CBBC)

CBBC is loaded from the database. Why is the calculation not working?

Labels (1)
2 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

Information is not enough. Can you upload sample.

There will be lot of reasons for that issue.

Not applicable
Author

Sorry, I attached the table in original message but for some reason it didn’t show up.

Table should look like this:

Date

No

Loss over IM

% of DF

12/02/2013

652

-152352

=LOSS_OVER_IM/sum(CBBC)

CBBC field is loaded from a database.

Loss over IM and % of DF are expressions and other fields dimensions. In the calculated field only (–) is displayed rather than percentage.

Hope this makes more sense now.