Calculation Expression Help

  • Thread starter Thread starter SITCFanTN
  • Start date Start date
S

SITCFanTN

I'm trying to add to my query the percentage of New Business Issued with a
Downpayment. In my query I'm counting the "RecordID" to count All New
Business Accounts and accounts with DownPayment have a code in the
DownPaymentCode field. I'm counting NB with Down Payments with the criteria
"is not Null". Now I'm trying to calculate in the Expression "PercentWithDP"
the New Business issued with Downpayments with the following
expressionhowever the result is zero.


PercentWithDP: [NBIssuedWithDP]\[NBIssued]

NBIssued: RecordID
NBIssuedWithDP: DownPaymentCode
 
Just a quick glance without reading or attempting to understand your records
and structure, your division sign is backwards. Using \ rather than / will
perform integer division. Results get rounded down to integers so every value
between 0 and 0.9999 will return 0.
 
Back
Top