Variable output into chart

[MrAndrews]

Hi

I have an app where I want a value to be dynamic based on a user choice, which is all ok.  However, they also want the choice 'title' to be shown in the table.

So the user chooses 'GWP', they see a value form GWP, and the word GWP in a different column.  I dont seem to be able to get it to change! The value is dynamic, but not the string.  Mock up attached.

Ta

[Lisa_P]

What do you need to see in the table and where do you need to see it ?

[MrAndrews]

Hi Lisa - In the column 'DriverDetailDesc' it should be the chosen option driver by the buttons above.   

If the driver name is Prem - it would be GWP or NWP. If the Driver Name is Claims it would be either NIC or Attr.

At the moment I can't get the literal to update in the DriverDetailDesc column, despite it updating the actual value in 'DriverValue'

Cheers!

[Lisa_P · Accepted solution]

Ok got it. Change your expression in the DriverDetailDesc field to:

=if(DriverName = 'Prem', '$(vPremDriver)' , '$(vClaimDriver)' )

[MrAndrews]

Ah mega! I really need to brush up on my dollar expansion.  I get super mixed up with when to and how to use.  Cheers!