Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
krithikarees
Contributor III
Contributor III

Sum two columns and Substract it in multibox

Hello All,

I am unable to sum two columns and subtract from a table in multi box .

TABLE CALCULATION :

Time to failure iS :  Rma issue date - ship date

Time to failure (today) is : today - ship date

Multi box calculation : =SUM(fabs(Interval(Today() - [Panel Ship Date]))) - SUM(fabs(Interval([RMA Issue Date] - [Panel Ship Date]))) 

but my totals in multi box are wrong.

Any help would be appreciated.

Thanks

2 Replies
vishsaggi
Champion III
Champion III

What is the total you are expecting to see? Specific reason behind using this expr in Multibox? Can you share sample app to look into? Please share you expected output...

sunny_talwar

Your table expressions are not using fabs function, whereas your multibox expression is... do you know why you use different expressions?