— The Forums are now read-only —
— All new activity now takes place here: —
Hello everyone,
I am looking to add a column in my Opportunities Generic Inquiry that simply multiplies two already existing columns, and displays the product. Is this possible?
I tried the following but it is breaking the GI:
Object: CROpportunity
Data Field: =[CROpportunity.AttributeWINCONF]*[CROpportunity.AttributeEVENTCONF]
Schema Field: blank
The above settings give me error: "Operand data type nvarchar is invalid for multiply operator."
If anyone has experience trying to display a product of two other columns (that are both displaying correctly), please help advise a solution. Thank you!
Try this, it should work.
=CInt([CROpportunity.AttributeWINCONF])*CInt([CROpportunity.AttributeEVENTCONF])
Good suggestion, I would use CDec instead of CInt, unless you are only working with whole numbers. Cint will round your figure to the nearest whole number.
By using this website, you agree to our Terms of Use (click here)
