I have following fields in the report
‘Item quantity required per piece’ bound field- number field : Field name in the report is [QUANTITY REQUIRED]
‘unit’- text filed- bound field: (Unit can be ‘GM’-for gram,’KG’- Kilogram,’PCS’- Pieces,’ML’-Milli Liter,’LIT’- Liter)- field name in the report is [QUANTITY UNIT]
‘total production’: number field: bound field: field name in the report [Text45]
Total item required for the production : Unbound : Field name in the report is [Text371]

For field [Text371], i want to create an expression . If the product of [QUANTITY REQUIRE] and [Text45] is greater than 1000 and if the unit is ‘GM’ then i want [Text371]=[Text45]*[QUANITY RQUIRED]/1000 &” “&”KG”( basically i want to convert the result to Kilogram if it’s more than 1000), otherwise, the result should be [Text371]=[Text45]*[QUANTITY REQUIRED] & ” ” & [Units] (basically if the product is not more than 1000 and the unit is not gram , i want the result to be just the product and the respective unit ) . I wrote the expression something like below, but it didn’t work :(. Could someone please help

IFF [Text45]*[QUANITY RQUIRED]>1000 & [QUANTITY UNIT]=”GM”, [Text371]=[Text45]*[QUANITY RQUIRED]/1000 &” “&”KG”,[Text371]=[Text45]*[QUANTITY REQUIRED] & ” ” & [Units]

​I have following fields in the report’Item quantity required per piece’ bound field- number field : Field name in the report is [QUANTITY REQUIRED]’unit’- text filed- bound field: (Unit can be ‘GM’-for gram,’KG’- Kilogram,’PCS’- Pieces,’ML’-Milli Liter,’LIT’- Liter)- field name in the report is [QUANTITY UNIT]’total production’: number field: bound field: field name in the report [Text45]Total item required for the production : Unbound : Field name in the report is [Text371]For field [Text371], i want to create an expression . If the product of [QUANTITY REQUIRE] and [Text45] is greater than 1000 and if the unit is ‘GM’ then i want [Text371]=[Text45]*[QUANITY RQUIRED]/1000 &” “&”KG”( basically i want to convert the result to Kilogram if it’s more than 1000), otherwise, the result should be [Text371]=[Text45]*[QUANTITY REQUIRED] & ” ” & [Units] (basically if the product is not more than 1000 and the unit is not gram , i want the result to be just the product and the respective unit ) . I wrote the expression something like below, but it didn’t work :(. Could someone please helpIFF [Text45]*[QUANITY RQUIRED]>1000 & [QUANTITY UNIT]=”GM”, [Text371]=[Text45]*[QUANITY RQUIRED]/1000 &” “&”KG”,[Text371]=[Text45]*[QUANTITY REQUIRED] & ” ” & [Units]   Read More

​