I have been having issues lately trying to acquire data from my “Products” dataset and using it to calculate LineTotal in another schema. The LineTotal columns does not return any values.
I recently came to this and figured the values from “Price” in “Products” isn’t being obtained as seen from the formula in the “OrderDetails” schema. I have already checked the field types, and even changed the type for “price” from money to number. From what I have seen there aren’t any typing errors too.
Any help would be appreciated!