Flow chart

[rathnam_qv]

Hi All,

i have create a flow chart as in attached image.

but i want to call the values in the table(Display Values, see the image) into the Text Object.

can anyone help me out.

Regards,

Rathnam.

[manideep78 · Accepted solution]

If that Chart is Static(If Display Label is static) you can do it using Set Analysis in each and every text object.

Write Below expressions in all the text objects that you need.

Booked:

Sum({<[Display Label]={'Booked'}>}[Display Value])

Billed:

Sum({<[Display Label]={'Billed'}>}[Display Value])

and so on.

Hope this helps.

Regards,

Manideep

[rathnam_qv]

Hi Manideep,

thanks for ur reply.

but i want to change my value format as $1,500,000

how to do that.

Regards,

Rathnam.

[manideep78]

Try this in the Text Object for every expression:

='$ '&Num(Sum({<[Display Label]={'Booked'}>}[Display Value]),'#,###.##')

Hope this helps you.

Regards

Manideep