Solved

Why Empty Row is added automatically in This Table and how to remove it.

  • 13 May 2023
  • 5 replies
  • 77 views
abhilashsawla
Userlevel 4
Badge +6

Hi 

I Have created a table, but an Empty Row is getting added there with data and not getting any Error while applying formula.

 Please help to solve this problem and Screen Shot is attached here for your reference.

 

icon

Best answer by Benoit 16 May 2023, 09:20

View original

5 replies

Benoit
Rank
Userlevel 6
Badge +12

Hi Abilash,

 

This one is interesting. Could you please screenshot your pivot configuration as show below?

Thanks.

 

Benoit
abhilashsawla
Userlevel 4
Badge +6

 

Benoit
Rank
Userlevel 6
Badge +12

Hi, Thank you for the screenshot.

I would be interested in seeing what is inside the A2 Type > F1 P&L pivot.

Is it possible that you have an (Empty) item in F1 P&L ?

 

If not, I suggest you create a Support ticket so we can give it a deeper look.

Please let me know.

Thanks,
Benoit

Benoit
abhilashsawla
Userlevel 4
Badge +6

Hi @Benoit 

I have empty mapping in A2 Type > F1 P&L so, because of that empty mapping an empty row is added.

If I use filter for F1 P&L items then that empty row is not coming.

Thanks for your support.

Benoit
Rank
Userlevel 6
Badge +12

Hi, thank you for your answer and glad it’s resolved.

It’s interesting to know!

Have a great day!

Benoit

Reply


Ask your question here!

Terms & ConditionsCookie settings