By using this website, you agree to our Terms of Use (click 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.