A recent Velixo update has broken some of my reports. I would use account turnover and where I reference the [Account] I would point at a cell for example A123, and in A123 I would reference the cells to be used in the calculation. Where I wanted multiple accounts, I would separate with a comma and everything worked. Well now I can’t figure out how to reference multiple accounts with this update.
Any ideas here?
Hello Nathaniel -
I tried to replicate what you describe, and I did not experience any issues:
(as you can see, my function referencing cell D3 returns the same value as if I summed up all the individual account turnover balances)
I would suggest reaching out with your report to the Velixo Help Desk ([email protected]).
ha, amazing, the differents in what you did above was not having a space in your cell D3. I had always had (in your example) 10100, 10200, 10300 etc.; the space made the difference.
Thanks for the help!
For future reference, this page https://help.velixo.com/support/solutions/articles/153000012270 contains information on all the different ways you can determine which accounts, subaccount or dimensions to use in a calculation
