Visual calculation

[AllanBerces]

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 Capacity] = "0" || BLANK(), [Vessel Capacity], [FC POB Plan])

Thnak you

[ChainsawMan · Accepted solution]

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.

[krishnakanth240]

Hi @AllanBerces 

Can you check try this and confirm

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

[FreemanZ · Accepted solution]

hi @AllanBerces ,

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

[AllanBerces]

Hi @krishnakanth240 @FreemanZ @ChainsawMan thnak you very much working perfetly

[krishnakanth240]

You're welcome @AllanBerces ! Could you please accept it as a solution if the calculation is working. Thank you

[ChainsawMan · Accepted solution]

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.