Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a doubt wether we can override the specified number format in table for a particular row.
My question will be more clear to you after looking at the file I attached.
My requirement:
I want the 9th row(Table is transposed) of my table to display
-40%
-.26%
-.10%
-31.51%
and i can't keep the number format as expression default.
Please let me know if anyone knows the solution. I am strugling with it from past few days and have tried my best.
Regards
Sagar Gupta
Hi.
Just set expression default format for all expressions.
Then correct your expressions this way:
=if(RowNo()='9', num($(vExpenditure), '#0.00%') , num(sum(Expenditure), '$#,##0'))
Hi.
You can set number format as expression default and then manually decide witch format to use for each expression.
Function num() can get you what you want.
You can even create more complex text representation than just changing a number format with dual() function.
If by 'row' you mean a particular dimension value, use if() statement to assign different number format depending on the dimension values.
Hi Whiteline,
Thanks a lot for reply, but I already tried all these options and none is working for me.
It would be much better if you can make a sample file and send it to me.
Regards
Sagar Gupta
Hi.
Just set expression default format for all expressions.
Then correct your expressions this way:
=if(RowNo()='9', num($(vExpenditure), '#0.00%') , num(sum(Expenditure), '$#,##0'))
Thanks Mr Whiteline
Regards
Sagar Gupta