If Else Count

[JayKay07]

Hi,

I have two columns: Item and Count

I have issuing in format. In count field some rows are figures (like 12,345) and some are percentages (like 45.8%). Please see the desire outcome for correct format. I am using this formula, but it is not working. Can anyone please assist? Thanks

if([Item]=('Rate'),sum(num(Count, '##0.0%')),sum(num(Count, '#,##0')))

[vinieme12 · Accepted solution]

Num() should be outside the measure,

Choose Number formatting =  Measure Expression

if([Item]='Rate',num(sum(Count), '##0.0%'),num(sum(Count), '#,##0'))

[JayKay07]

Thank you