Hello,
I have insterted a table in the attached document and I would like to insert in theG:26 a formula:
=CONCATENATE("VAT";" ";K25;" %")
The problem is that instead of having the desire result: "VAT 21 %".
I get "0". Would you know how to insert the formula in the header of a table??
(In G22 you have the expected result)
Many thanks,
Graig
It is not possible to use formula in header of table - I think because this will break structured reference formulas when header changes.
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
You can only use static text for column headers of tables, as they are named fields.
You could use a bit of code to rewrite the header when the VAT rate changes:
But be careful - this may cause errors in DAX formulas which reference this field name.
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks