Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Remove blanks from a column

I am trying to calculate portfolio cash weight. The portfolio always has a percentage which is not invested and therefore doesn't sum to 100%. I have a measure which calculates this cash weight (Cash...
Need Help
  • tex628's avatar
    tex628
    7 years ago
    CashWt = IF([TotalWt] = BLANK() , BLANK() , 100 - [TotalWt])
tex628's avatar
tex628
Community Champion
7 years ago
CashWt = IF([TotalWt] = BLANK() , BLANK() , 100 - [TotalWt])
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks, works perfectly!