topic Re: Set Expression logic in App Development

Set Expression logic

Anku — Mon, 24 Oct 2022 05:35:04 GMT

Hi all, Please refer below snapshot;

Where it is direct, it's easy but to some names the values should be an output of calculation as shown above e.g., Name "C".

Note: all Names have their respective Keys which has some values ( which are itself a output from an expression). Also, only expression is required, script level changes not possible.

Thanks.

Re: Set Expression logic

vinieme12 — Tue, 25 Oct 2022 03:23:21 GMT

as below

=sum(value) / sum(TOTAL <Name> value)

Re: Set Expression logic

Anku — Wed, 26 Oct 2022 18:14:19 GMT

Thanks for your response.

Provided expression will divide each cell value with overall sum.

However, here I am looking for an expression which can divide values against respective names having num and denom in logic column.

Eg, Name "A" will show as 7681 (key is 1) however name "C" will be the out put of 7521/6920 ( key 45/67).

Thank you

Re: Set Expression logic

vinieme12 — Thu, 27 Oct 2022 13:39:35 GMT

=Alt( sum({<Logic={'Direct'}>}Value) , sum({<Logic={'Num'}>}Value) / sum({<Logic={'Den'}>}Value) )

Re: Set Expression logic

Anku — Sat, 29 Oct 2022 05:10:51 GMT

Thanks, Alt was not working hence IF used,

IF([COMPUTING LOGIC] = 'DIRECT',sum({<[COMPUTING LOGIC] ={'DIRECT'}>}VALUE),
NUM((sum({<[COMPUTING LOGIC]={'Num'}>}VALUE) / sum({<[COMPUTING LOGIC]={'Den'}>}VALUE)),'###0%' ))