Forum Discussion

TexasBI's avatar
TexasBI
Icon for Helper II rankHelper II
9 years ago

How to create a calculator?

Hello,   I am trying to create a calculator that will calculate monthly price of a product for 12 months plus a 1 time price for a product in the first month. Example if I get a product for $10/mon...
Need Help
nickchobotar's avatar
nickchobotar
Icon for Skilled Sharer rankSkilled Sharer
9 years ago

Hello,

 

On high level for your model you want to three dimension tables (Customer, Product and Date) and one fact (transactions ) table.

Let me know if this is something you are looking for and we can continue with formulas.


goaltender36's avatar
goaltender36
Icon for Helper I rankHelper I
9 years ago

hey nickchobotar

 

I think I see what your getting at. This would be a presales calculator so it would be generic but i see what your getting at