# Scott Anderson CCIM

• Total activity 55
• Last activity
• Member since
• Following 0 users
• Followed by 0 users
• Subscriptions 13

Recent activity by Scott Anderson CCIM
• This worked perfectly for me.   kostennetto = +(((kostennetto + mwst)/0.01)*0.01).toFixed(2) Rainer you're amazing at this calculation stuff!  Thank you.

• Found this thread which solved my problem.  The calculation rounds to 2 decimal places and preserves the field as a number field (not a text field) so that it can be used it additional calculations...

• @Rainer  - I could use your help with a rounding issue.  I read this entire thread and your input about how the Calculation field determines if the field is a number or text field was VERY helpful ...

• Really need this as well.  I have found how to round a calculated sum using  .toFixed(2)  but then there is no way to use those rounded sums in further calculations.   For Example.. If I have Field...

• Yes Jean-Claude Massé - the message pattern is always the same.  Thank you.

• Hi Rainer,  Thank you again for your calculation prowess! I mis-typed when I said, "I want to input it into its own field using Podio Calculation".  Disregard, I know it needs to be in a calculatio...

• Excellent!  Thank you Rainer I will try it out.  Thank you!

• I have a similar challenge but with all fields being in the same app.   I am trying to calculate the average of several individual category fields.  There are about 8 category fields with the categ...

• I had to make some changes to my field names - but the following ultimately is what worked for me!! Thanks Rainer! var suite = @All of Calculation; // take the title field var cat = @All of St...

• THANK YOU Rainer. The 'and/or' was sloppy writing on my part.. the category field is only single-select - not multi-select. So your first formula's will work fine. I will try them out as soon as I ...