By using this website, you agree to our Terms of Use (click here)
Hi - is there a way to within unit sets define the value of a unit set as equal to the sum/difference of two other unit sets?
Below example i want to make Gross Profit (Unit 00030) equal to difference of Revenue (Unit 00010) and COGS (Unit 00020). Is that possible?
Thanks
Hi Joseph,
I tried putting a Sum function in the Value column of your screenshot that referenced other Unit Set codes (you can do that on the Row Sets), but it didn't do anything.
I'm curious though, are you sure you want Unit Sets here? Normally I see this kind of grouping done on the Row Sets.
If you were to setup Revenue and COGS as Rows, then you could do a calculation in the Value column of the Row Sets screen that references other rows.