How to replace the value 0 value with text

[Karim_Khan]

Hi Team,

    I am trying to replace the zero (0) value with Text ( No.Of Booking 2015).

I am getting some value as 0 in the column of Monthly YOY and Copy of YOY I want to replace this values by No.Of bookings 2015.

Regards,

KK

MRKachhiaIMP‌jagan‌gwassenaar‌ashfaq_haseeb‌Kush141087‌

[MK_QSL]

You can have

IF(YourExpression = 0, 'YourText',YourExpression)

[Kushal_Chawda]

check monthly copy YOY expression

see the attached

[sasiparupudi1 · Accepted solution]

please see the attached file

[Karim_Khan]

Hi Sir,

     There is a minor change in the condition.Suppose if there is a 0 zero value in Monthly 2014 column then it should show 'No FY Booking 2014' in Monthly Copy YOY cloumn.and if there is a 0 zero value in Monthly 2015 column then it should show 'No FY Booking 2015' in Monthly Copy YOY

I am trying to create the scenario with below expression

=if(v2014=0,'No FY Booking 2014' or v2015=0,'No FY Booking 2015',([Monthly 2015]/[Monthly 2014])-1))

Variable store value

v2014='$' & round(num(sum({$<[Fiscal Year] = {'2014'},[Month in Fiscal Year] = {'$(=only([Month in Fiscal Year]))'}>} [Net Bookings]),'##.00'))

v2015='$' & round(num(sum({$<[Fiscal Year] = {'2015'},[Month in Fiscal Year] = {'$(=only([Month in Fiscal Year]))'}>} [Net Bookings]),'##.00'))

Regards,

KK

[Karim_Khan]

    There is a condition.Suppose if there is a 0 zero value in Monthly 2014 column then it should show 'No FY Booking 2014' in Monthly Copy YOY cloumn.and if there is a 0 zero value in Monthly 2015 column then it should show 'No FY Booking 2015' in Monthly Copy YOY

I am trying to create the scenario with below expression

=if(v2014=0,'No FY Booking 2014' or v2015=0,'No FY Booking 2015',([Monthly 2015]/[Monthly 2014])-1))

Variable store value

v2014='$' & round(num(sum({$<[Fiscal Year] = {'2014'},[Month in Fiscal Year] = {'$(=only([Month in Fiscal Year]))'}>} [Net Bookings]),'##.00'))

v2015='$' & round(num(sum({$<[Fiscal Year] = {'2015'},[Month in Fiscal Year] = {'$(=only([Month in Fiscal Year]))'}>} [Net Bookings]),'##.00'))