Rounding issue

[Waterfowl_Waterfowl_hunte (Waterfowl Waterfowl hunter)]

From the JSON File:
Convert.ToInt32(Row(“cost”)) → Cost = .01
Convert.ToInt32(Row(“quantity”)) → Quantity = 1

Formula:
Assign “amt_per_quantity → Cost/Quantity = 0 (should equal .01)

Not sure how to set up the assign so its not rounding down to zero.

[supermanPunch (Arpan)]

Hi @Waterfowl_Waterfowl_hunte ,

Maybe Try Converting to Double and check :

[neha.upase]

Hi,
Based on your description, you want to calculate Cost / Quantity . To ensure the result doesn’t round down to zero, you need to use floating-point division. Here’s how you can set up the formula in the right side of the assign
amt_per_quantity = Convert.ToDouble(Row(“cost”)) / Convert.ToDouble(Row(“quantity”))

[Waterfowl_Waterfowl_hunte (Waterfowl Waterfowl hunter)]

I received this strange message when the debug reached the assign activity. This is a strange message i have never seen before. thoughts?

[ppr (Peter Preuss)]

Change Inverted Double quotes to "

[neha.upase]

Hi,

Disable first two TotalPrice and Quantity assign activities. you already converted that rows to double in following assign.
Convert.ToDouble(Row(“cost”)) / Convert.ToDouble(Row(“quantity”))

[Waterfowl_Waterfowl_hunte (Waterfowl Waterfowl hunter)]

Thank you @neha.upase. this worked! I appreciate the help.