Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi Community,
Is there any way we can associate values in front end.
For Ex:
for Lineno 129k, I need to get values of GA6(a.08,a.8a,a.08b) but at the back end it is not associate so do we have any set to get their values of GA6(a.08,a.8a,a.08b) without changing script.
added dummy data.
Like this?
Expression
If(Only({1}LineNo) = '129k', Sum(TOTAL {<GA6 *= {'A.08', 'A.08a', 'A.08b'}, LineNo>} BSAmount), Sum(BSAmount))
You need this where? for each time the LineNo is 129k, you want to see the same number repeating?
not necessary, if we get like that then it is very good, else it is fine the number
Sorry, what? I am not sure I follow you? I am not sure the kind of output you are looking to get... for the sample provided, can you provide the numerical output you are hoping to get?
Expecting Like this
You can very easily get the first one like this
If(LineNo = '129k', Sum(TOTAL {<GA6 = {'A.08', 'A.08a', 'A.08b'}>} BSAmount), Sum(BSAmount))
that is good idea, but if I drill down further for ex if I select 129k then I am getting only a.08 value only i.e 26 so do we have any other solution to keep 48 only even if I drill down
Ignore selection in LineNo or use 1
If(LineNo = '129k', Sum(TOTAL {1<GA6 = {'A.08', 'A.08a', 'A.08b'}>} BSAmount), Sum(BSAmount))
or
If(LineNo = '129k', Sum(TOTAL {<GA6 = {'A.08', 'A.08a', 'A.08b'}, LineNo>} BSAmount), Sum(BSAmount))
Thanks Sunny for helping on it, I am getting the values as expected but when we take any other filters then our results are not correct, for ex take one more filter GA6, select a.08a then it should be value of a.08a but it is not happening.
I understand this functionality should be from backend but still trying front end as many reports will get disturb if I commint backend changes.
Like this?
Expression
If(Only({1}LineNo) = '129k', Sum(TOTAL {<GA6 *= {'A.08', 'A.08a', 'A.08b'}, LineNo>} BSAmount), Sum(BSAmount))