Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have to listboxes with field names MTH_SHORT_DESC and FIN_YR_NO . When i select 2018 for eg it shows 2018 data only , why is the ignoring of fields not working ? Ive done this before a 100 times
(Sum({<MTH_SHORT_DESC=,FIN_YR_NO=>} Contribution) * Sum({<MTH_SHORT_DESC=,FIN_YR_NO=>}GL_VALUE) / count({<MTH_SHORT_DESC=,FIN_YR_NO=>}DISTINCT Cost_Centre)) / count({<MTH_SHORT_DESC=,FIN_YR_NO=>}distinct YR_MTH_NO)
What is vRounding in your expression? It seems like a variable, are you ignoring selection within that? If not, then that might be where you need to ignore selection....
I also tried ignoring all selections
(Sum{1} Contribution) * Sum({1} GL_VALUE) / count({1}DISTINCT Cost_Centre)) / count({1}distinct YR_MTH_NO)
can you post your example or screenshot of it.
Regards,
Did this work when you ignore everything? Or did this not work as well?
Nope , both doesnt work
What is vRounding in your expression? It seems like a variable, are you ignoring selection within that? If not, then that might be where you need to ignore selection....
Il try that , vrounding is a field which divides by 1 , 1000 , 1 billion ,
if i comment out vrounding it behaves how i want it to , seems like that is the problem
Like I said, you need to ignore selection in the fields within the variable as well