Replace the value with conditional

[Karim_Khan]

Hi Team,

     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'))

Regards,
KK

MRKachhiaIMP‌jagan‌gwassenaar‌ashfaq_haseeb‌Kush141087‌

[MK_QSL]

You can use something like below instead of v2014 and v2015

IF(round(num(sum({$<[Month in Fiscal Year] = {'$(=only([Month in Fiscal Year]))'}>} [Net Bookings]),'##.00')) = 0,'No FY Booking ' & Max([Fiscal Year]),

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

[Karim_Khan]

no it is not working

It should be change on the basis of values in other column

[Kushal_Chawda · Accepted solution]

try this condition in your expression

if([Monthly 2014] =0,'No FY Booking 2014',

if([Monthly 2015]=0,'No FY Booking 2015',

if([Monthly 2014]=0 and [Monthly 2015]=0,'No FY Booking 2014 & 2015',

([Monthly 2015]/[Monthly 2014])-1)))

[Karim_Khan]

Tnx bro