Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
Have a field 'Division' and would like the below expression to ignore any selections made to the field 'Divison' but the value changes when anything else is selected.
Num(
If([Numerator Only Flag] =1 And Sum(Numerator),
If([Numerator Only Flag]=1 And Summarise=0, Only(Numerator),
If([Numerator Only Flag]=0 And Summarise=1,Sum(Numerator)/Sum(Denominator),Only(Numerator)/Only(Denominator)))),[Format Code])
Something like this perhaps:
Num(
If([Numerator Only Flag] =1 And Sum({<Division=>}Numerator),
If([Numerator Only Flag]=1 And Summarise=0, Only({<Division=>}Numerator),
If([Numerator Only Flag]=0 And Summarise=1,Sum({<Division=>}Numerator)/Sum({<Division=>}Denominator),Only({<Division=>}Numerator)/Only({<Division=>}Denominator)))),[Format Code])
Try you use set Analisys
Num(
If([Numerator Only Flag] =1 And Sum({$<Division = >}Numerator),
If([Numerator Only Flag]=1 And Summarise=0, Only({$<Division = >}Numerator),
If([Numerator Only Flag]=0 And Summarise=1,Sum({$<Division = >}Numerator)/Sum({$<Division = >}Denominator),Only({$<Division = >}Numerator)/Only({$<Division = >}Denominator)))),[Format Code])
When I put the above code on the table acts weird.For some Indicators the format changes but the values remain the same and the values change to null which looks like the selection in the list box 'Division' is affecting the table . I checked the format and its correct.
Please see screenshots attached.
you can attach file QVW or file data?
Sorry mate. I cant do it coz of confodential data. Will probably anonamize it and send it.
I am struggling to find a solution to it. Never really came across something like this.
Okay
try this
Num(
If([Numerator Only Flag] =1 And Sum({$<Division = >}Numerator),
If([Numerator Only Flag]=1 And Summarise=0, Only({$<Division = >}Numerator),
If([Numerator Only Flag]=0 And Summarise=1,Sum({$<Division = >}Numerator)/Sum({$<Division = >}Denominator),Only({$<Division = >}Numerator)/Only({$<Division = >}Denominator)))), only({$<Division = >}[Format Code]))
or
Num(
If(only({$<Division = >}[Numerator Only Flag]) =1 And Sum({$<Division = >}Numerator),
If(only({$<Division = >}[Numerator Only Flag])=1 And only({$<Division = >}Summarise)=0, Only({$<Division = >}Numerator),
If(only({$<Division = >}[Numerator Only Flag])=0 And only({$<Division = >}Summarise)=1,Sum({$<Division = >}Numerator)/Sum({$<Division = >}Denominator),Only({$<Division = >}Numerator)/Only({$<Division = >}Denominator)))), only({$<Division = >}[Format Code]))
Hi all. Thanks for your suggestions. I got it sorted with this bit of code
Num(
If([Numerator Only Flag] =1 And Sum({<Division -= >}Numerator),
If([Numerator Only Flag]=1 And Summarise=0, Only({<Division -= >}Numerator),
If([Numerator Only Flag]=0 And Summarise=1,Sum({<Division -= >}Numerator)/Sum({<Division -= >}Denominator),Only({<Division -= >}Numerator)/Only({<Division -= >}Denominator)))), only({<Division -= >}[Format Code]))