How to access a particular column value in beast mode calculation?

Reply
Highlighted
White Belt

How to access a particular column value in beast mode calculation?

salience.JPG

I want to calculate Salience =  This Year/ Total ( 500,000 / 980,000 )

and based on filters Total value will be dynamic

is it possible to access 980,000 to access in beast mode? Please tell me how to write a beast mode for this.

 

Black Belt

Re: How to access a particular column value in beast mode calculation?

Unfortunately, you can't do totals like this in beast mode. You will need to do this in SQL or Magic ETL. It would be a nice enhancement if beast mode could eventually grab these totals as it is a common question.




**Make sure to like any users posts that helped you and accept the ones who solved your issue.**
Announcements
Want to join our weekly online meet up? Please visit this board here and let me know. Click here for more details!