Conditional formula

[Oros]

Hello,

What would be the correct measure or custom column to get the correct TOTAL BOXES SOLD in reference to the SOLD BY.

For example, if SOLD BY= PIECE, then TOTAL BOXES SOLD=SOLD QTY/PIECES PER BOX, otherwise TOTAL BOXES SOLD.

Thanks.

[DataVitalizer]

Hi @Oros 
You can create a calculated column with the following formula

TOTAL BOXES SOLD = if(SOLD BY= "PIECE", SOLD QTY/PIECES PER BOX,SOLD QTY)

Did it work ? 👌 Mark it as a solution to help spreading knowledge 👉 A kudos would be appreciated

[Oros]

Hello @DataVitalizer ,

Thank you for your quick reply.  I tried the formula but gave me this error:

[DataVitalizer]

Can you make sure that your columns are decimal? just to check if there is a text value " in one of your rows instead of numeric values

[Arul · Accepted solution]

@Oros ,

I am not sure whether I have understand your requirement right but this what I have come up with in a calculated column,

New Column = IF(TableName[SOLD BY] = "PIECE",TableName[SOLD QTY (BOX OR PIECE)]/TableName[PIECES PER BOX],TableName[TOTAL BOXES SOLD])

Thanks,

Arul

[Oros]

Hello @Arul ,

Thank you for your quick reply.  I tried the formula but gave me this error:

[Arul]

@Oros ,

I think columns used in this columns are text data type. Can you change the data type to whole number and try?

Thanks,

Arul