Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
=Alt( sum({<Logic={'Direct'}>}Value) , sum({<Logic={'Num'}>}Value) / sum({<Logic={'Den'}>}Value) )
as below
=sum(value) / sum(TOTAL <Name> value)
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
=Alt( sum({<Logic={'Direct'}>}Value) , sum({<Logic={'Num'}>}Value) / sum({<Logic={'Den'}>}Value) )
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%' ))