Forum Discussion

CHaines's avatar
CHaines
Advocate I
3 years ago
Solved

Find difference only if 2 columns are present, else blank

I expect only to get a result only if both are present. If either is blank, or both are blank, I expect a blank result. Sample data showing each case. Blank cells are intentionally blank, and RoutePr...
Need Help
  • Barthel's avatar
    Barthel
    3 years ago

    Hey CHaines,

    Do your columns have the data type 'Whole Number' or 'Decimal Number'? If so, your own calculation should work. Anyway, it works for me:

Barthel's avatar
Barthel
Solution Sage
3 years ago

Hey CHaines,

Do your columns have the data type 'Whole Number' or 'Decimal Number'? If so, your own calculation should work. Anyway, it works for me:

CHaines's avatar
CHaines
Advocate I
3 years ago

I found the problem! I think I had not updated or something when I changed from 

RoutePriceChange = AllChanges[SecondPlanRouteValue] - AllChanges[FirstPlanRouteValue]

 to having some ISBLANK() checks.