# CurrentValue issue

**URL:** <https://connect.superhuman.com/t/currentvalue-issue/14977>\
**Category:** Ask the Community\
**Created:** [April 7, 2020, 9:48pm UTC](https://connect.superhuman.com/t/currentvalue-issue/14977 "2020-04-07T21:48:07Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Andr](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/andr/32/9651_2.png) [@Andr](https://connect.superhuman.com/u/Andr)\
**Post date:** [April 7, 2020, 9:48pm UTC](https://connect.superhuman.com/t/currentvalue-issue/14977/1 "2020-04-07T21:48:07Z")

</div>

Hi there,  
do you know the reason CurrentValue takes 2 different forms in the same formulamap?  
It seems to me that the second CurrentValue is not returning anything at all, and filtering is not working.

 ![image](https://global.discourse-cdn.com/coda1/original/2X/8/8214002683070a76680b25c6d860b8a4b4266fdf.png)

---

<div class="post-metadata">

**Author:** ![Paul\_Danyliuk](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/paul_danyliuk/32/27228_2.png) [@Paul\_Danyliuk](https://connect.superhuman.com/u/Paul_Danyliuk)\
**Post date:** [April 7, 2020, 9:54pm UTC](https://connect.superhuman.com/t/currentvalue-issue/14977/2 "2020-04-07T21:54:37Z")

</div>

Yes, this doesn’t work. It’s been discussed a lot, like here:

> [@Outer CurrentValue access](https://connect.superhuman.com/t/outer-currentvalue-access/8048):
>
> Hello there! I have a table with one unique column and one non-unique. I want to print a list of all dirrefent values in second column with numbers of items match these values. I think here in my screenshot second CurrentValue should be white as first, and should refer to FormulaMap context, not to CountIf. How can I do this?

`Filter()` and filter-like formulas, `ModifyRows()` and `AddOrModifyRow()`, nested `FormulaMap()` will all overwrite `CurrentValue` with the one from the current context. Currently there’s no way to access CurrentValue from the outer context.

There are workarounds though, and often it’s possible to restructure the formula to get the desired result. Not so easy in your case though, if you want to have a live formula, but it can be implemented with either actions or an extra table.

---

<div class="post-metadata">

**Author:** ![Andr](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/andr/32/9651_2.png) [@Andr](https://connect.superhuman.com/u/Andr)\
**Post date:** [April 8, 2020, 4:55pm UTC](https://connect.superhuman.com/t/currentvalue-issue/14977/3 "2020-04-08T16:55:40Z")

</div>

Thanks.  
I’ll try to think about some workaround, but it’s going to make my system more convoluted…

---

<div class="post-metadata">

**Author:** ![system](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/system/32/24484_2.png) [@system](https://connect.superhuman.com/u/system)\
**Post date:** [October 5, 2021, 5:50pm UTC](https://connect.superhuman.com/t/currentvalue-issue/14977/4 "2021-10-05T17:50:49Z")

</div>

Closed on October 5, 2021, 5:50pm UTC

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
