Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!, I´m trying to calculate the percentile value of an variable (expense) in function of another variable (revenues) in one same dimension (count).
I have tried many different ways to solve problem, without sucess
If possible to make the percentage in function of the ID (ID=1, 500)
ID count value change% (objective)
1 revenues 500 =500/500
2 expenses 50 =50/500
If I understood your question correctly, this should work (where 1 is the ID of the field that you are dividing by):
Sum (value)/FieldValue('value',FieldIndex('ID',1))