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...
AlexisOlson
Super User
Super UserYour code looks like it works if you change all of the IDs to text:
I'd advise against hard-coding the non-"1" IDs though.
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
Probably 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?