Calculated measure on New model

[dd5]

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"

[Sowmiya_C]

Hi dd5,

Kindly please find the below screenshot, Hope this will useful for you

In this scenario, I have created an account dimension and assigned Gross_sales and Net_Value as members for the account dimension and then added [ Discount] as a property for the dimension member as below.

Thanks,

[dd5]

Hey sowmiya98

thanks - looks good, but it's not what I'm trying to do - I need to calculate the percentage out of a given sum.

that way - and I'm afraid that it's not possible on the fly

thanks

[Jay_Gandhi]

Hi there,

If all the values you need are in one measure then you can still use account formulas to create calculated accounts which take Account A/Gross Sales Account.

You could then create multiple calculated accounts that represent Account A in the above example.

Jay

[dd5]

Hey jgandhi88

I can't see your example

but I'll refine my question is the below need possible on the fly or should it be a data action

I want to calculate the measure "PERCENT_GS" as a division:

VALUE divided by Gross-sales VALUE

thanks

[Sowmiya_C]

Hi dd5,

Can you please explain your scenario in detail? Because from my understanding you want to get values which is [VALUE/Gross Sales]

Here VALUE and Gross Sales both are measures?

Thanks,

[dd5]

Hey sowmiya98 , thanks!

VALUE is the measure

others are accounts:

Gross sales

COGS

EBIT

and I added a % from GS Measure

thanks

Deb