topic Re: Get a percentage based on the parent value from different column in App Development

Get a percentage based on the parent value from different column

younlim91 — Wed, 23 Feb 2022 03:20:18 GMT

Hello,

I want something like below in column C. What would be the expression to use for this? Basically, Column C is column A/ parent value in column B

	A	B	C
X	10	20	0.5
Y	3		0.15
Z	7		0.35
D	20	100	0.2
E	10		0.1

Re: Get a percentage based on the parent value from different column

Iswarya_ — Wed, 23 Feb 2022 07:47:33 GMT

Hi @younlim91

You can use IsNull() and Peek() to achieve this. Attached script.

test:
LOAD
trim(replace(F1,chr(160),'')) as F1,
A,
"B"
FROM [lib://AttachedFiles/test data.xlsx]
(ooxml, embedded labels, table is Sheet1);

Final:
LOAD *,
A/B1 as C;

Load *,
IF(IsNull(B),Peek(B1),B) AS B1
Resident test;
DROP Table test;

Re: Get a percentage based on the parent value from different column

Iswarya_ — Thu, 17 Mar 2022 10:19:58 GMT

If the issue is solved please mark the answer with Accept as Solution