AnsweredAssumed Answered

Trouble With Calculations

Question asked by CeciliaBaldwin on Sep 3, 2013
Latest reply on Sep 3, 2013 by CeciliaBaldwin

Title

Trouble With Calculations

Post

     I'm trying to make a couple of calculations, and I'm not sure what I'm doing wrong in the script. All my fields are in the same table, but when it goes to make the calculations, it either uses one field with reference or does nothing at all. I'm not certain if I also need to a georefresh button so that's it is certain to wait until all necessary information is included. (This is being done in a portal, in a TO table).

      

     First calculation is division -both fields are number fields - and read: 

     "Price per Unit" = Div ( price per quantity ; units per )

     Then, I want to take the average of the 6 most recent entries of the same field .I was originally going to make this field a summary field, selecting average of, but , as I need this field (called mean for z) to be referenced in a different portal, (say new field "portal 2 m" = look up of "mean for z" , but it will not read that value. If i do it as a regular number, it will; just not as a summary. 

      

     Again, I'm not sure if I need a refresh button or what is the best way for going about this. Appreciate any help!

      

Outcomes