javascript computation yield different result

Asked Sep 22 '21 at 17:55

Active Sep 22 '21 at 17:55

Viewed 48 times

I want to get the same value with the result from the excel sheet but the computations yield a different result , anyone has an idea why ? I cant get the -13 percent from the excel?

I think my e Nullish Coalescing Operator is correct also.

#excel

#ts code

this.dealDispositionFormFields.salePrice = 10000000
this.dealDispositionFormFields.brokerCommission = 125000
this.dealDispositionFormFields.transactionCosts = 50000
this.dealDispositionFormFields.netBookValue = 11250000


  calc() {
    this.netProceeds = (this.dealDispositionFormFields.salePrice ?? 0) - (this.dealDispositionFormFields.brokerCommission ?? 0) - (this.dealDispositionFormFields.transactionCosts ?? 0);
    this.netSaleGainLossRate = (this.netProceeds ?? 0) - (this.dealDispositionFormFields.netBookValue ?? 0);
    this.netSaleGainLossPercentage = (this.netSaleGainLossRate ?? 0)/(this.dealDispositionFormFields.netBookValue ?? 0);
  }

#current result

asked Sep 22 '21 at 17:55

Ananya Amar

2

The values look the same to me. Which ones are you referring to? – 001 Sep 22 '21 at 17:57
2

times 100, decimal to percentage? 1/2 = .5 ... x100 = 50% – depperm Sep 22 '21 at 17:57
1

what is your problem? – Vulwsztyn Sep 22 '21 at 17:58
3

_I cant get the -13 percent from the excel?_ `-00.13` is `-13%`. You just need to format it differently. – 001 Sep 22 '21 at 18:00
@JohnnyMopp In excel the result is -13% but in my js code the result is different even using the same formula – Ananya Amar Sep 22 '21 at 18:00
what is the name of thae formal @JohnnyMopp ? that would convert -00.13 to - 13%? – Ananya Amar Sep 22 '21 at 18:01
2

-00.13 is the same thing as -13%... – Jacob Sep 22 '21 at 18:01
what is the specific name of the convertion Sir ? so that I will know – Ananya Amar Sep 22 '21 at 18:02
do you mean decimal to percentage right ? – Ananya Amar Sep 22 '21 at 18:03
2

this.netSaleGainLossPercentage = Math.floor(this.netSaleGainLossPercentage * 100) + '%'` – 001 Sep 22 '21 at 18:06
Also another question Sir , why is that on excel the B10-B7 does not yield a negative answer? – Ananya Amar Sep 22 '21 at 18:09
1

It is negative. Excel represents negative money values by putting them in parentheses `( )`. – 001 Sep 22 '21 at 18:10

javascript computation yield different result

0 Answers0