Unit of Measure

[Former Member]

Hello,

I have a variable to convert all Gross weight with UOM in KG to LB.

I just don't understand why I can't get one single value per Fiscal year.

[Former Member · Accepted solution]

The Column Weight LB is a variable based on UOM...so all values under Weight in LB are in LB.

If I filter out the UOM the value that was converted from kilo to LB will disappear.

Weight in LB variable: =If [UOM] = "KG" then Gross weight * 2.25 else Gross weight

I only have gross weight in Kg or LB.

thank you,

[amitrathi239 · Accepted solution]

HI

use this in UoM column.

=replace([UoM];"KG";"LB")

Amit

[Former Member · Accepted solution]

Hi Amit,

I got multivalues with the Replace formula.

Essentially what I need to do is convert all Gross weight from KG to LB so I can have a unique UOM and a single value per Fiscal year period.

[amitrathi239 · Accepted solution]

Hi,

In this case no need to replace the KG values with LB.As you have already converted the KG values to LB.

Weight in LB variable: =If [UOM] = "KG" then Gross weight * 2.25 else Gross weight

in this case instead of UOM object you can simply add the text LB because your all values are already in LB.

Also check what is the datatype of Weight in LB variable?

Amit

[Former Member · Accepted solution]

If I remove the UOM object from the block, the weight in LB variable shows several multivalues.

Weight in LB variable is a number data type

[amitrathi239 · Accepted solution]

Hi,

try with sum function in Weight in LB  column.

=sum(Weight in LB)

Amit

[Former Member · Accepted solution]

I think that because the Weight in LB variable refers to Object UOM even if I sum (which I tried) I still get 2 values for each Fiscal year period. One value showing UOM KG (even thought the value is converted from KG to LG) and one value showing UOM LB.

Is there another variable that I can use to convert the Gross weight from KG to LB but get one single value per fiscal period?

Ex: Fiscal period 2015/02 = I have 5,000Kg and 2,000 LB. I want to be able to show: Weight for Fiscal Year period = 7,000 LB

[amitrathi239 · Accepted solution]

Hi,

Makesure Period object data type should be Number.

After that use this for LB variable=Sum(If([UoM]="KG") Then  ([Gross]*2.25) Else [Gross])

See attached screenshot.

Amit

[Former Member · Accepted solution]

The data type in Period is text. How do I convert to numbers?

[amitrathi239 · Accepted solution]

Hi,

even my report is working with string data type.

you can try with this.

=ToNumber([Period];"#####")

Amit

[Former Member · Accepted solution]

This formula worked! Thank you so much Amit!

[amitrathi239]

HI,

reason is delivery  period is having year & different months.if you will extract the year part only the you will get the two val for one year.KG & LB year values by year.

Amit

[Former Member]

Even if I use Fiscal Year Period, I still get one value for KG and one for LB.

Is there a way to get one value for LB only per Fiscal year period?

[Former Member]

Apply report level filter on object UoM & filter should be like

UoM = 'LB'.

This will give you only 1 row.

I hope this will help.

Thanks,

Swapnil

[amitrathi239]

Hi,

in this case right click on the table or cell apply the filter on UoM select the value LB.

Amit

[Former Member]

Hi ,

If you want to have single record per fiscal year then you have to drag Fiscal year object instead of Delivery Period object.

If you don't have Fiscal year object then you can create one using following logic:

Fiscal_Year = Substr([Delivery Period],1,4)

Now use this object instead of Delivery period object.

I hope this will get you your desired output.

Thanks,

Swapnil