Forum Discussion
Solved
Measure if error values
Hi, I need to remove by using If error I think the following data marked in red: I have the following measures at the moment : Var LCR = [Actual LCR]-[Forecast LCR] Var LCR % = IFE...
Hi,
Try this
=IF(ISBLANK([Actual LCR]),BLANK(),IFERROR([Var LCR]/[Forecast LCR],BLANK()))
Hi,
Try this
=IF(ISBLANK([Actual LCR]),BLANK(),IFERROR([Var LCR]/[Forecast LCR],BLANK()))