Forum Discussion

MickK's avatar
MickK
New Member
4 years ago
Solved

How to assign a portion $ from one field against string values

Folks,    I have an excel that contains 2 cells. The first contains a total value $ and the second is a list of who that value is assigned to. In some cases, the assigned is a single dept, in other...
  • rocky09's avatar
    4 years ago

    Here you go. You need to modify the data in the M code. Here I am attaching a sample file for your reference.

    https://1drv.ms/u/s!AilGKsSdStq8kTzm2cP2xPlfRdPd?e=wUdHEz
  • rocky09's avatar
    4 years ago

    If your issue resovles. Please accept my reply as Solution.