Forum Discussion
gauravnarchal
Post Prodigy
Post ProdigyHow to Calculate Sales Revenue Split
Hello - I want to check if there is a possibility to Divide the total sale amount of agent 1 in the division 5000 by 4 (Divide by 4) and add each it to the total sale amount to the agents 123...
gauravnarchalPost Prodigy
Post ProdigyAlexisOlson - The measure is now working. The only issue I am having is when I add the name to the table, the split measure does not work. What could be the reason?
AlexisOlson
Super User
Super UserProbably the additional filter context. Try adding ", ALL ( ARInvoices ) " inside the first CALCULATE.
- gauravnarchal
AlexisOlson - Still the same issue. When I am adding any other column, the split formula doesn't work. What could be the reason?