December 2020 Product Adoption Tip: Calculation & Time Conversion Cheat Sheet!

You won’t create new formulas in your cube very often. New formulas are usually a staple of building a new cube, but beyond that it isn’t a typical task - and remembering how all the different formula types function across your dimensions (i.e., at leaf levels vs. a parent level) isn’t exactly like riding a bike.

Our Product Adoption Team developed this amazing cheat sheet to explain how the different formula types and time conversions function with your account type dimension.

Prophix - Calculation and Time Conversion Methods Examples - Web Client.xlsx (469.4 KB)

Let us know if this helps!

This is very helpful. Thank you.

1 Like

Thank you. I’m always in for cheat sheets.

1 Like

Very helpful. Great tip

Helpful tips which can be used for adoption

Thanks! Cheat sheets are always appreciated!

very useful summary of calculation methods. It would be better to provide some example of using formula in time conversion.

1 Like

Thank you for sharing. Might come in handy

Thanks for sharing! This will be a good resource.

I’m a big fan of cheat sheets! Thank you.

Thanks for sharing this cheat sheet!

Thank you for sharing this!

Thank you! I love cheat sheets!!

Thank you for sharing!

Thanks for sharing, would def like to incorporate some of the mentioned items!

I love being able to have reference sheets like this! THank you!!!

Thank you for sharing!

Love cheat sheets! More Cheat Sheets!

Cheat sheets are the best! Thank you! Keep them coming!

Saving this for reference - thank you for sharing!