Forum Discussion
Combination Value.Divide() and Value.Add() returns all null results?
Hi guys!
I don't even know how to share this dataset both with the model, except to share the real WOrkbook. I can't do that because there is client data in it.
If you mean "are the fields that I am adding and then dividing of the proper data type" BEFORE I use them in my calculation - the answer is yes.
- [Website purchases value] is imported from .csv and properly declared (automatically) as 1.2 (decimal number);
- [Mobile purchases value] is imported from .csv and properly declared (automatically) as 1.2 (decimal number);
My first calculation of correcting [Mobile purchases value] works.
= if List.Contains({"iPhone", "iPad", "iPod"}, [Impression Device]) then ([Mobile app purchases conversion value]/2) else [Mobile app purchases conversion value]After this step, I change the type of this new column to decimal number.
Now I try to use this new column in the second calculation, as in my post above, both of the fields in question have been declared as decimal number, and it simply does not work.