Write, Bureaucrats, Administrators
4,332
edits
How:Slice & Dice Library Data: Difference between revisions
Jump to navigation
Jump to search
m
no edit summary
mNo edit summary |
mNo edit summary |
||
| Line 46: | Line 46: | ||
=== Calculate with related data === | === Calculate with related data === | ||
Then, | Then, add any calculations within the newly-expanded Orders library that will assist in data analysis. | ||
; Add these fields to Orders: | ; Add these fields to Orders: | ||
:* '''Product margin''' — [[JavaScript field]] | :* '''Product margin''' — [[JavaScript field]] | ||
::* Either using the '''+Field''' button or by just typing, enter this script: | ::* Either using the '''+Field''' button or by just typing, enter this script: | ||
<source lang="JavaScript">field('Product std price') - field('Product cost')</source> | <source lang="JavaScript"> | ||
field('Product std price') - field('Product cost') | |||
</source> | |||
:* '''Order margin''' — [[JavaScript field]] | :* '''Order margin''' — [[JavaScript field]] | ||
::* Enter this script: | ::* Enter this script: | ||