Forum Discussion
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
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.
hi AllanBerces ,
try like:
Calculation = IF([Vessel Capacity] = 0 || ISBLANK([Vessel Capacity] ), [Vessel Capacity], [FC POB Plan])
5 Replies
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.
hi AllanBerces ,
try like:
Calculation = IF([Vessel Capacity] = 0 || ISBLANK([Vessel Capacity] ), [Vessel Capacity], [FC POB Plan])Hi krishnakanth240 FreemanZ ChainsawMan thnak you very much working perfetly
You're welcome AllanBerces ! Could you please accept it as a solution if the calculation is working. Thank you
Hi AllanBerces
Can you check try this and confirm
Calculation =
IF(ISBLANK([Vessel Capacity]) || [Vessel Capacity] = 0,[Vessel Capacity],[FC POB Plan])
