[Datamart-News] OBIEE formula reminder

[WALLACE Aaron * DAS]

OBIEE users,

Whenever you create a formula, in OBIEE, you must have all the fields, used in the formula, within the 'selected columns' of the 'Criteria' section. If not, it will cause calculation errors and provide incorrect formula data.

Example: If you create a formula of 'Cost divided by Hours'. You must make sure to have the fields of 'Hours' and 'Cost' included within the 'Selected Columns' of the 'Criteria' section.
[cid:image001.png at 01DA27A0.81B75FA0]

Thanks,
Aaron Wallace
Sr. Datamart Business Analyst

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://omls.oregon.gov/pipermail/datamart-news/attachments/20231208/42090377/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 36371 bytes
Desc: image001.png
URL: <https://omls.oregon.gov/pipermail/datamart-news/attachments/20231208/42090377/attachment.png>