0 Missing

[priyarane]

Hi Community,

0 is missing as attached possible value is 0% only.

[Anonymous]

Share the sample data.

[priyarane]

Hi Balraj, This is huge application and not possible to shar.. Could you please help me in front end

[Anonymous]

Well,

Check out the Number format of RWA%, you can select Show in percentage option

[priyarane]

same option selected

[Anonymous]

well, then I need sample data.

See if you can create Inline and share it?

[Anonymous]

share the metrics of RWA%

[sujeetsingh]

Priya this seems that there are some nulls due to your expression hence try using len(complete expression)=0,0,Expression).

Many times the expressions give such output like Sum/Total here if Total is there and sum is 0 then it is always null

[jagan · Accepted solution]

Hi,

Is it 0 or Null in that rows?  If there are Null values then it shows empty values.  Can you try using Alt() like below

LOAD

Alt(RWA, 0) AS RWA,

'

'

'

FROM SourceTable;

Hope this helps you.

Regards,

Jagan.

[Anonymous]

Hi Jagan,

What is the advantage of ALT() function?

I tried to fined out in QV help but did not get what exactly it does?