Convert Int into Decimal
I am trying to update a decimal field using a formula (within a business process) which calculates two integer value fields. The result is getting displayed as either 1 or 0, so I am assuming I need to carry out some sort of (decimal) conversion. This is the query. Anyone know best way to achieve this?
(([#read 1.First item of resulting collection.Int1#]-[#read 1.First item of resulting collection.Int2#])/[#read 1.First item of resulting collection.Int1#])*100
Like
you can use Convert.ToDecimal( (([#read 1.First item of resulting collection.Int1#]-[#read 1.First item of resulting collection.Int2#])/[#read 1.First item of resulting collection.Int1#])*100 )
Julio.Falcon_Nodos,
thanks for reply. I did try that before but for some reason it keeps returning the value as 0.0 when I know the correct value is not that. Strange