Calculation Expression Help

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
 
D

Duane Hookom

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.
 
Top