Jump to content
  • 0

Calculated Field In View




I have been searching for the ability to store a calulated value in i view, but so far I have only found that in DataPages.

More spesific, I have made a huor registration table, then a view as a source for the DataPage to report these hours.

In the report,, I want to group hours by year, month and project, but the only values I can group by is the data that are already stored (and not the ones calculated in the DataPage).

The only solution I can think of at the moment would be to calculate month and year in the registration DataPage, and then store the values in the hour Table allthough this really is a violation against normalization. (I don't consider it a vioaltion to store it in a view).


Link to comment
Share on other sites

1 answer to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...