Question about divide() function

[kaoticfury]

so here is my situation, i have 2016 Jan to Dec bookings, and 2017 Jan to March bookings. I am trying to use divide to do a Y/Y growth %. The results looks fine from 2017 Jan to March. However, from 2017 April to Dec, i got -100% because there is no actual yet in 2017.....how to make these -100% to be blank? 

thank you!!

[v-sihou-msft · Accepted solution]

@kaoticfury

DIVIDE() function can only deal with "0" denominator scenarios. Now you can want to apply condition based on current row, so you have to use IF statement.

=
IF (
    [Bookings CY] = BLANK (),
    ( [Bookings CY] - [Bookings LY] )
        / [Bookings LY],
    BLANK ()
)

Regards,