Forum Discussion

Supermat's avatar
Supermat
Icon for Helper I rankHelper I
4 years ago
Solved

Sconto a cascata

Quando vi trovate nella situazione di avere un prezzo lordo più una serie di sconti, qual'è secondo voi il miglior modo di calcolarlo? Considerando che magari in alcuni casi gli sconti non ci sono o ...
Need Help
Show and Tell
Tips and Tricks
  • v-angzheng-msft's avatar
    v-angzheng-msft
    4 years ago

    Hi, Supermat 

     

    You could create a calcualted column like this:

    Column = 
[Gross_Price]*(1-[Discount_1]/100)*(1-[Discount_2]/100)*(1-[Discount_3]/100)

    Result:

     

    If this is not the result you want, please provide examples of what you want as a result, it makes it easier to give you a solution.

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-angzheng-msft's avatar
v-angzheng-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, Supermat 

 

You could create a calcualted column like this:

Column = 
[Gross_Price]*(1-[Discount_1]/100)*(1-[Discount_2]/100)*(1-[Discount_3]/100)

Result:

 

If this is not the result you want, please provide examples of what you want as a result, it makes it easier to give you a solution.

 

 

Best Regards,
Community Support Team _ Zeon Zheng


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Supermat's avatar
Supermat
Icon for Helper I rankHelper I
4 years ago

Thx for your support.