Forum Discussion
Dynamic format measures in subtitles
Hi all! Thanks in advance for your time. I have encountered a rather small issue, but one non the less. It seems that when I include a dynamically formatted measure in another measure for the su...
Nevermind guys, I knew it was a silly question. Just in case anyone is interested, I solved it by adding the dynamic format of the DELIVERY_COST_PT inside the subtitle measure:
SUBTITLE_DELI_COST_PT = "DELIVERY COSTS PT: " &
SWITCH(TRUE(),
[CURRENCY_SELECTED] = "EUR", FORMAT([DELIVERY_COST_PT], "#,##0.00 €;- #,##0.00 €; #,#00.00 €"),
[CURRENCY_SELECTED] = "CHF", FORMAT([DELIVERY_COST_PT], "#,##0.00 fr;- #,##0.00 fr; #,#00.00 fr"),
[CURRENCY_SELECTED] = "GBP", FORMAT([DELIVERY_COST_PT], "#,##0.00 £;- #,##0.00 £; #,#00.00 £"),
[CURRENCY_SELECTED] = "USD", FORMAT([DELIVERY_COST_PT], "#,##0.00 $;- #,##0.00 $; #,#00.00 $"))