Export Dual() function as number in excel

[cchausse]

Hi all,

When I want to export data from a graph with Dual() function, it exports the text format from Dual() instead of numeric value.

Formula:

if(SUM(IMPORT) > 1000000,

dual(num(SUM(IMPORT)/1000000, '#.##0M', ',', '.'),SUM(IMPORT)),
if(SUM(IMPORT) > 1000,
dual(num(SUM(IMPORT)/1000, '#.##0K', ',', '.'),SUM(IMPORT)),
num(SUM(IMPORT),'#.##0', ',', '.')))

It works very well on the graph.

BUT when I export the data to excel:

I want the real number, not the text version from Dual().

Example:

202008: 480000000, 448000000, -32000000

How can I do it?

Thanks!

[ArnadoSandoval]

Hi @cchausse 

Perhaps this may help; Add an Alternative Measure without using your Dual() expression, assign a meaningful name, you can select either the Measure with the Dual function or the new one, without it, as shown by the following screenshots; now selecting the Measure without the Dual function allows you to export the original figures.

Hope this helps,