Forum Discussion

AllanBerces's avatar
AllanBerces
Post Prodigy
6 months ago
Solved

Visual calculation

Hi good day can anyone help me correct my visual calculation. if Vessel Capacity is equal to 0 and blank then the result is Vessel Capacity else the FC POB Plan Calculation = IF([Vessel Capaci...
Need Help
  • ChainsawMan's avatar
    ChainsawMan
    6 months ago

    Hi，
    Ensure you are referencing the columns/measures exactly as they appear in the visual matrix：

    Calculation = IF([Vessel Capacity] = 0 || [Vessel Capacity] = BLANK(), [Vessel Capacity], [FC POB Plan])

    You could check whether the [Vessel Capacity] is text or a number.

     

  • FreemanZ's avatar
    FreemanZ
    6 months ago

    hi AllanBerces ,

     

    try like:
    Calculation = IF([Vessel Capacity] = 0 || ISBLANK([Vessel Capacity] ), [Vessel Capacity], [FC POB Plan])

ChainsawMan's avatar
ChainsawMan
Helper I
6 months ago

Hi，
Ensure you are referencing the columns/measures exactly as they appear in the visual matrix：

Calculation = IF([Vessel Capacity] = 0 || [Vessel Capacity] = BLANK(), [Vessel Capacity], [FC POB Plan])

You could check whether the [Vessel Capacity] is text or a number.