Forum Discussion
Anmolgan
Post Prodigy
Post ProdigyMerge blank field in calculations?
Hi, I have 2 tables where I am making the relation with a whole number id column, below is the visual that i am trying to build but the problem is that I want to add -1,233.84 balance in all the paye...
Anmolgan , I do not see any reason why that number should add. Unless your calculation do not consider it.
Greg_Deckler
Community Champion
Community ChampionCan you provide sample data and any formulas you have? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Do you want to add that balance equally across all of the payertypes or is it supposed to be distributed?
Best method would be to fix the bad data that is causing the blanks.
AnmolganGreg_Deckler I want to add the amount equally to all the payer types.
- Greg_DecklerSorry Anmolgan , just so I am clear, you want to divide the number by the number of payer types and add that amount to each OR you want to add that amount to each of the payer types? Either way it is adding an equal amount but it makes a big difference in the total. I am assuming the 1st option is what you want.
- Anmolgan
Greg_Deckler 1st option is the correct.