Forum Discussion

KB88's avatar
KB88
Frequent Visitor
1 year ago
Solved

Simulated Weighted Average Payment Term using What-If Parameter

I am trying to use a what-if parameter to make a simulated weighted average payment term measure. I have 2 files, 1 with payment terms and the number of days associated. The other file is the main da...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi KB88 ,
Could you please confirm if the issue has been resolved on your end? If a solution has been found, it would be greatly appreciated if you could share your insights with the community. This would be helpful for other members who may encounter similar issues.
Thank you for your understanding and assistance.