This content has been marked as final.
Show 4 replies

1. Re: calculated field to find difference
Tushar More Oct 7, 2018 8:35 PM (in response to Alysse Mea)
Help_v10.5_1.twbx 102.4 KB


2. Re: calculated field to find difference
Mahfooj Khan Oct 7, 2018 9:13 PM (in response to Alysse Mea)Hi,
You have to little bit modify your before and after formula, find my approach below
[Before Formula Value  New]
{INCLUDE [Employee Name]:AVG(if [Stage]='BEFORE' then [Formula]
end)}
[After Formula Value  New]
{INCLUDE [Employee Name]:AVG(if [Stage]='AFTER' then [Formula]
end)}
[Diff]:
SUM([After Formula Value  New])SUM([Before Formula Value  New])
[% Diff]:
[Diff] / SUM([After Formula Value  New])
Let us know if this help.
Mahfooj

Help_v10.5_v10.5.twbx 102.9 KB


3. Re: calculated field to find difference
Alysse Mea Oct 8, 2018 11:45 AM (in response to Alysse Mea)Thank you, Mahfooj! Your formula worked

4. Re: calculated field to find difference
Mahfooj Khan Oct 8, 2018 12:07 PM (in response to Alysse Mea)Glad I could help kindly mark my reply as correct so that, this thread gets closed and others can take benefits who have similar query.