Eclipse Community Forums: BIRT » Profit shows NaN instead of result

Help

Home

Home » Archived » BIRT » Profit shows NaN instead of result(Nan result calculating profit using a computed column)

Show: Today's Messages :: Show Polls :: Message Navigator

Profit shows NaN instead of result [message #1820762]

Tue, 28 January 2020 13:17

Stuart Oxley

Messages: 8
Registered: January 2020

Junior Member

Hi,

Can someone please help?

How can I enter a computed column calculation without getting a NaN result for (homenettvalue-standardunitcost) / homenettvalue As Profit

Is there another way I can do the calculation?

I already have a margin calculation in SQL:
homenettvalue-standardunitcost & the profit calculation also works in SQL, by including (homenettvalue-standardunitcost) / homenettvalue As Profit in BIRT, gives zero division error, I have used ISNULL for other columns, this does not work for Profit.

In the expression builder I have tried:

row["Margin"]/row["homenettvalue"] which gives me either a result of 1 or 0

Using: row["homenettvalue"]-row["standardunitcost"]/row["homenettvalue"]

This gives me the homenettvalue result, using Aggregation: SUM gives me NaN

Report message to a moderator

Re: Profit shows NaN instead of result [message #1841549 is a reply to message #1820762]

Thu, 20 May 2021 11:14

Stuart Oxley

Messages: 8
Registered: January 2020

Junior Member

Hi,

NaN is an error value that means not a number.
However, JavaScript considers the type of NaN to be number.
Infinity is a value so big it can't be represented by JavaScript numbers. It acts mostly like mathematical infinity.

Check the calculation and try again

Report message to a moderator

Previous Topic:	Page footer displays in wrong place when preview in Web Viewer/print the report
Next Topic:	Survey as part of my bachelor thesis

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 15:04:56 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter