SAC Data Action - Adv formulas Script - Use dimension property for calculation

[axel_]

Hello SAC Gurus,

in one of my data action scripts I want to calculate with a dimension custom property (which is setup as decimal).

Script looks like this:

However SAC complains no viable alternative at input '[d/FLUGZTYP].[p/NOX]'

Can I use a dimension custom property in a calculation?
If yes, how?

Thanks for all replies in advance!

Best regards
Axel

[N1kh1l · Accepted solution]

axel_

Use ATTRIBUTE function to read property values within DATA() statement.

ATTRIBUTE([d/FLUGZTYP].[p/NOX])

-Nikhil

[Andrew128 · Accepted solution]

Hi Nikhli,

I want to ask is it possible that, we using attribute to get the result ? 

For example: 

[d/date].[p/year]  - [d/analytics2].[p./year]  = and locate the figure under "[d/wbs].[p/year]"

let's say 

[d/date].[p/year] = 2024

[d/analytics2].[p./year] = 2020

= 4

So the figure "4" will identify which "[d/wbs].[p/year]" that i want to park the figure back to the 

@N1kh1l 

Thank You 

Best Regards

Andrew