topic Re: SET EXPRESSION LOGIC in App Development

SET EXPRESSION LOGIC

Anku — Sun, 23 Oct 2022 05:11:47 GMT

Hi all,

I have a table script which has 2 different computation logic:

1. Direct: Here, I can get values for respective names

2. Division: Names' value need to be calculated by dividing keys, here, I am getting issues.

Kindly suggest how to proceed here. Note: Script can't be amended.

Below is the sample input table & desired output:

Note: For ease I have shown values column in input though it is in fact table.

Thank you.

Re: SET EXPRESSION LOGIC

ckarras22 — Sun, 23 Oct 2022 07:08:20 GMT

Hello,

Please use the code below

IF(COMP_LOGIC='DIVISION', NUM(AGGR(ABOVE(VALUE),COMP_LOGIC,NAME,VALUE)/AGGR(BELOW(VALUE),COMP_LOGIC,NAME,VALUE),'###%'),VALUE)

Re: SET EXPRESSION LOGIC

Anku — Sun, 23 Oct 2022 12:56:39 GMT

Thanks @ckarras22 , no doubt above expression is working as expected to the dataset given however just an amd required (which is in point 2).

I need your help for:

1. My "value" column is a set expression, still they will work inside agg(above(sum({$<conditions>}Values)….

2. The dataset actually has Num,Denom values instead of division (as I was thinking "Key" column is more imp), refer below:

3. Query: Name F is a outcome of keys calculation ie 12/11 & Name G itself is key 11. So, I think calculation made using keys will be more helpful, what are your thoughts?

Thank you.