Create calculated field by Removing Duplicates

[cvievard]

Hello

In an excel, I have in one column the event IDs, in another the list of partners I have organized events with and the other column the cost. Sometimes, one event will be organized with two partners so the cost will be stated twice. However, when calculating the total cost, I want these duplicated to be ignored. How can I do this ? 

[ArkadyZagdan]

@cvievard You can do this by cleanning your data first before plugginng it into a BI solution like all Profesionnalls do.