SOLVED

Formula

Copper Contributor

Hello, I am trying to change a formula, the formula is =([@[Detail Total]]*(1+[@[Tax Rate]]+[@other]-[@Deposit]

In this formula, it is only applying the tax rate to the detail total. I am changing the "Other" to something else that needs to be taxed. Would anyone be able to direct me in the right direction as to how to do this correctly? Thanks in advance

3 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@AprilGreenway 

How about

 

=([@[Detail Total]]+[@other])*(1+[@[Tax Rate]])-[@Deposit]

@Hans Vogelaar 

Thank you so much. Not sure what I was doing wrong, but that worked for me. I really appreciate your assistance.

@AprilGreenway 

I placed the parentheses differently.

1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
Solution

@AprilGreenway 

How about

 

=([@[Detail Total]]+[@other])*(1+[@[Tax Rate]])-[@Deposit]

View solution in original post