https://community.qlik.com/t5/QlikView/if-condition/m-p/1781615#M1232338 <P>there is data in column like&nbsp;</P><P>56.98 MB</P><P>45.67 GB</P><P>i want if data has MB then want to multiply by 0.1 if not then same value will load which is in data ..</P><P>how I do that in script&nbsp;</P> Mon, 26 Jan 2026 16:26:21 GMT capriconuser 2026-01-26T16:26:21Z https://community.qlik.com/t5/QlikView/if-condition/m-p/1781615#M1232338 <P>there is data in column like&nbsp;</P><P>56.98 MB</P><P>45.67 GB</P><P>i want if data has MB then want to multiply by 0.1 if not then same value will load which is in data ..</P><P>how I do that in script&nbsp;</P> Mon, 26 Jan 2026 16:26:21 GMT https://community.qlik.com/t5/QlikView/if-condition/m-p/1781615#M1232338 capriconuser 2026-01-26T16:26:21Z https://community.qlik.com/t5/QlikView/if-condition/m-p/1781669#M1232341 <P>Can you provide more info..&nbsp;</P><P>seems like column is of type $text; What exactly are you expecting.. when you say multiply by 0 to a $text field ?</P><P>Anyways, look into Right() and WildMatch() script functions.</P><P>Also just a tip; Keep data type i.e. MB, GB info into separate field.&nbsp;</P> Wed, 10 Feb 2021 14:36:59 GMT https://community.qlik.com/t5/QlikView/if-condition/m-p/1781669#M1232341 PradeepK 2021-02-10T14:36:59Z