Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have 2 tables that are not connected but have similar values. For example in the first table there is a 'year' field and in the second table there is a 'byyear' field. How can I make calculations on the second table according to selections of the values in the first table?
Something like that: (I know the formula is wrong, it's just for example)
sum({<byyear={getselectedvalue(year)}>}amount)
Thanks!
@Amit_B Will you be able to change field name from second table with first table like
Load byyear as Year, .....
So that, Year field is common for both table and you can use with Sum(Amount)
Hello,
You need to use the P() function.
Like this :
Does it fit you expectation ?
Best Regards,
Antoine L
Try this:
=sum({<byyear={$(=GetFieldSelections(year))}>}amount)
Regards,
Aditya
I select values in 'year' field and need the 'byyear' field to be updated, so I wrote it like this:
sum({<byyear=P(year)>}amount
When I check it with filter panes it works, but in the kpi (set analysis formula) I get 0.
Something like this maybe ? Is that what you want ?
Try this
Create variable
vSelectedYear =GetFieldSelections(year)
Use below
sum({<byyear={"$(=vSelectedYear)"}>} amount)