Costas
Member
Hi Chandoo,
I’ve set up a Sales summary report with sumifs formulas and links to a Jet reports table. They work fine…well, until I run the Jet Reports refresh which deletes and recreates the table, resulting in all my links turning into refs. Below is a formula before and after refresh.
=SUMIFS(GLEntry[Amount];GLEntry[GL No.];"41000";GLEntry[Month];$B$4;GLEntry[BU];$C5;GLEntry[IG];D$4)
=SUMIFS(#REF!;#REF!;"41000";#REF!;$b$4;#REF!;$C5;#REF!;D$4)
Is there a way I can fix my formulas so they don't get updated during the refresh process? I've already tried switching the calculation to manual but Jet Reports switches it back to Automatic.
I've also tried to Replace all from "=" to " '=", running the refresh and replace back from '= to = but some of the formulas to not revert back and stay as text.
Has any of you come across this before?
Thanks
Costas
I’ve set up a Sales summary report with sumifs formulas and links to a Jet reports table. They work fine…well, until I run the Jet Reports refresh which deletes and recreates the table, resulting in all my links turning into refs. Below is a formula before and after refresh.
=SUMIFS(GLEntry[Amount];GLEntry[GL No.];"41000";GLEntry[Month];$B$4;GLEntry[BU];$C5;GLEntry[IG];D$4)
=SUMIFS(#REF!;#REF!;"41000";#REF!;$b$4;#REF!;$C5;#REF!;D$4)
Is there a way I can fix my formulas so they don't get updated during the refresh process? I've already tried switching the calculation to manual but Jet Reports switches it back to Automatic.
I've also tried to Replace all from "=" to " '=", running the refresh and replace back from '= to = but some of the formulas to not revert back and stay as text.
Has any of you come across this before?
Thanks
Costas