Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a straight table in my dashboard with a list of dates. Not every row has a date, some are null so I want the total of this column to be the count of dates. If I select count as the total function it does count them correctly but it is formatting it as a date. How do I format this as a number?
I've checked the dimensionailty of the header is 0 and have tried the following in the custom format pattern of the column in question but it just writes the words rather than formatting it:
=IF(Dimensionality()=0,'#,##0','DD/MM/YYYY')
Hi
use the format in the expression and change the number formatting as "Measure expression"
Try like below
=if(dimensionality() = 0, num(urexp, '#,##0'), date(urexp, 'DD/MM/YYYY'))
Hi
use the format in the expression and change the number formatting as "Measure expression"
Try like below
=if(dimensionality() = 0, num(urexp, '#,##0'), date(urexp, 'DD/MM/YYYY'))
That's brilliant, thank you so much for your help.