This content has been marked as final.
Show 1 reply

1. Re: Sum_product
Simon Runc May 15, 2015 1:36 AM (in response to Arihant Jain)hi Arihant,
So to get the SumProduct, the formula is actually very similar to the one you've posted!
So from your attached the formula in Excel is
=SUMPRODUCT(D2:D64*E2:E64)/SUM(D2:D64)
and for all rows (unfiltered) this is 56.8
In Tableau the formula is;
SUM([Amount in USD]*[Payment Days])/SUM([Amount in USD])
As you say you can then use a quick filter to just look at January, for a particular supplier (as per the attached).
Hope this is what you were after, but if not please post back

Sum Product SR.twbx 46.2 KB
