Forum Discussion
Simulated Weighted Average Payment Term using What-If Parameter
Hi KB88 ,
Thank you again for the update!Since you have already created a disconnected Vendor table, the key is to ensure you're using that disconnected table in your slicer ,not the one that is linked to SC data.If the slicer is based on a table with a relationship, it will still filter the data and affect the weighted average calculation.
Please double-check that the slicer is pointing to the disconnected Vendor table only. Once that is confirmed, your logic might work correctly across all vendors.
Did you get a chance to review my earlier response? If not, please have a look on it and let us know.
Thank you.
Hi KB88 ,
I wanted to check in on your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply that helped you or sharing your solution. It would be greatly appreciated by others in the community who may have the same question.
Thank you.
Sorry for the delay! I have not found a solution to this. I have broken it down step by step and there seems to be an issue with the filtering in one step of the way. I had used up too much time and had to take a pause on this project.
Hi KB88 ,
Thanks for the update! The issue likely comes from the vendor slicer directly filtering your main data table. When that happens, the measure ends up calculating the weighted average only for the selected vendor, instead of all vendors. The key fix is to use a separate, disconnected vendor table for your slicer. This way, the slicer doesn’t filter the data, it just tells the measure which vendor’s payment term to override. Please let us know if you found any solution or workaround.
Thank you for your cooperation.Have a great day!
Regards,
Pallavi.That is the issue! If I remove filtering from the slicer, I get the correct number I am looking for in that step. I have a separate Vendor Name table that I created for this, that is linked to SC Data via Vendor name. I inserted that into the slicer, but am still getting the incorrect numbers.
Hi KB88 ,
Thank you again for the update!Since you have already created a disconnected Vendor table, the key is to ensure you're using that disconnected table in your slicer ,not the one that is linked to SC data.If the slicer is based on a table with a relationship, it will still filter the data and affect the weighted average calculation.
Please double-check that the slicer is pointing to the disconnected Vendor table only. Once that is confirmed, your logic might work correctly across all vendors.
Did you get a chance to review my earlier response? If not, please have a look on it and let us know.
Thank you.