Export Dual() function as number in excel

cchausse — Sat, 16 Nov 2024 00:33:28 GMT

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!

Re: Export Dual() function as number in excel

ArnadoSandoval — Mon, 01 Mar 2021 06:29:38 GMT

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,

topic Re: Export Dual() function as number in excel in App Development

Export Dual() function as number in excel

Re: Export Dual() function as number in excel