Want an override when aggregate measure not showing data

[Anonymous]

I am trying to show a factor based on a date; however, I want the aggregate to be the division of the aggregated totals (i.e. . When there is no claim the completion factor is coming in blank, but I would still like it to populate for a row context. I tried using IF(ISBLANK(LOOKUPVALUE... but then that shows rows that have no data. Is there a way to only show data for the rows that have premium data or claims?

[d_gosbell · Accepted solution]

---

@Anonymous wrote:

 Is there a way to only show data for the rows that have premium data or claims?

---

Couldn't you just add these checks to your IF expression ?

eg.

IF ( ISBLANK( DIVIDE(  ...  )) && ( NOT(ISBLANK( [Gross Premium] )) || NOT( ISBLANK( [Paid Claims] ))) , ...

[Anonymous]

Thank you! Adding in the criteria NOT(ISBLANK(...) around my premium field did the trick!