Hey there, I am trying to create a widget that shows the total amount of currently unredeemed vouchers. My current widgets are Original Paid Amount with a filter for the "Purchase" price type. and another for the "redeemed" price type. When I try to make an equation subtracting the two, it gives me an error. Formula; (SUM(Original Paid),(Price Type - Purchase)) - (SUM(Original Paid),(Price Type - Redeemed)) Error definition in functions (SUM): Expected numeric expression, found "set" Any ideas on how to accomplish this, or why this equation is not working?
Thanks all!
Is that formula a copy/paste from the formula editor? If not, would you do that, or screenshot?
sum([Ticket Original Paid Amount],[Price Type1])-SUM([Total Ticket Original Paid Amount]),([Price Type2])
Update this part
SUM([Total Ticket Original Paid Amount]),([Price Type2])
To this
SUM([Total Ticket Original Paid Amount]),[Price Type2])
Extra "(" before price type filter.
Sorry, Michael, my prior comment was incorrect:
( SUM ( [Ticket Original Paid Amount] ) , [Price Type1] ) - ( SUM ( [Ticket Original Paid Amount] ) , [Price Type2] )
Aha, too many parentheses. Much appreciated Chris!!