 Rank: Advanced Member
Groups: extranet\Forum
Joined: 4/12/2019(UTC)
Posts: 41
|
Hi What is the formula to calculate difference from last week in this table?  BR Lotte
|
|
|
|
|
|
Rank: Advanced Member
Groups: extranet\Forum
Joined: 5/16/2019(UTC)
Posts: 11
|
Hi Lotte,
I believe you could use sum(d-1, 0, m1, 0) - sum(d-1, 1, m1, 0).
The only problem I see is that for your last item on the table the Diff would be itself.
Hope it helps!
Danilo
|
|
|
|
|
|
Rank: Advanced Member
Groups: extranet\Forum
Joined: 4/12/2019(UTC)
Posts: 41
|
It works perfect, thanks Danilo.
A visiblity agent fixes last row ;o)
|
|
|
|
|
|
Rank: Advanced Member
Groups: extranet\Forum
Joined: 5/16/2019(UTC)
Posts: 11
|
Awesome, glad it worked! :)
|
|
|
|
|
|
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.