Good day,
Is there a way to display the Averages per Document in an Embedded view?
I have an embedded view showing a single category as I can’t get the “Shared, private on first use” to work. On the Shared, private on first use view, I have put the selection formula → @Name([CN];@Username) = @Name([CN];InitiatedBy), but they can still view all.
Any ideas?
Thanks
Subject: Embedded view OR Shared, private on first use view
As i understand it , Show Single Category option only uses top category to work, If you add an additional category below it then it should show in the embedded view and you can display the average there.As for the private view, the formula you have should work:
SELECT @Name([CN];@Username) = @Name([CN];InitiatedBy)
Unless you made this change to the design after having created another version of the view and viewing it on the client. When you open a private on first use view on the client it will create a local copy of the view and it won’t see any changes in design until you delete the private view so it will be created again, the easiest way to do this is to remove the db icon from the workspace (a warning will show) then open the db again.
Subject: RE: Embedded view OR Shared, private on first use view
The problem is that the category row, showing the average, is not shown. You could, I suppose, add a second categorized column with the same value in it, so that only the first one would be hidden; or, you could have a computed field near the embedded view to use @DbLookup to pull the values and compute the average.
I would not use a private on first use view for this (or anything else, basically); but if you must, make it desktop private and the selection formula should work better.
Subject: RE: Embedded view OR Shared, private on first use view
Thank you, I’d rather stick with embedded view.
I have added another column, categorized, given it the formula “Average” and it now shows the average at the top. But still not the totals at the bottom, but that shouldn’t matter.
Thanks again!