Forum Discussion
Small correction: Total Net ROI / Total Revenue = 510,000 / 15,000,000 = 3.4% and not 3.14%
I guess this is where scripts can come in handy. However, there is no documentation whatsoever on how to write them.
Here is something you can try
Remove the Summary on that label, add a script on the before print event.
Imaging that 4.7 is called as label47, 510000 is called as label45, and 15,000,000 is called as label46
Then this will give you what you are looking for.
Private Sub label47_BeforePrint(ByVal sender As Object, ByVal e As System.Drawing.Printing.PrintEventArgs)
dim decRevValue as decimal = Decimal.Parse(me.label46.Summary.GetResult())
dim decROIValue as decimal = Decimal.Parse(me.label45.Summary.GetResult())
me.label47.text = decROIValue/decRevValue
End Sub
- Cosimo3 years agoContributor II
Thanks KING!
At first I was getting an error where the code was not recognizing GetResults() function but after adding a few DevExpress Imports, it works!
- ckattookaran3 years agoVIP
Glad it worked. I’m surprised I didn’t import those DevExpress ones. Maybe it is 6.5 and I’ve everything on one machine.
- Cosimo3 years agoContributor II
I still like using Studio rather than the embedded Report Designer within the Windows app.
In any case, thanks again for the code example. Wish someone gave a thorough course on advanced OneStream Studio development.
Related Content
- 2 years ago
- 4 months ago
- 6 months ago
- 10 months ago