Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I was trying to create a textbox based on a chart value which I detached at one point to hold the value constant. I am unable to get the calculated value for the text box based on this constant chart value. Is there anything I am missing or any help regarding this?
Thank you.
Roshni.
It is difficult to help you by just looking at the description. May be try this:
Sum(Aggr(YourChartExpression, YourChartDimensions))
If the above doesn't work, would you be able to provide a sample?
I have now got the values in the shipped Qty Chart which I am freezing as in Detaching using a macro to remain constant.
The text box currently has only the formula same as the chart ( To show the sum of the shipped Qty in this case). The text box does not show me the same number which I froze previous,
Did I make sense?
Thanks,
Roshni.
I see 5 text boxes in total and I am not sure which two you are talking about. Can you try to be more specific please.
Only the PPM box is a text box. the LED display is a chart.