Skip to Content
0
Apr 27, 2022 at 12:15 PM

Calculated measure on New model

301 Views

Sorry if it's an easy one, but I don't know how to do it:

I have a NEW SAC model with a chart account that builds a P&L. (let's say Gross-sales, COGS and Gross profit)
I have a measure of "VALUE" and I would like to create a calculated measure that will take every line in my "value-P&L" and divide it with gross sales

I just don't find how to write it - I've made few trials more or less like the one below, (with resultlookup or lookup) but they were not valid - I must miss something:

thank you
Deb

[VALUE]/[d/ACCOUNT]="GROSS_SALES"