This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

The calculation of a value shows 0

Posted on 03-14-2025 03:50 AM
JFL73
New Member
Reply posted on --/--/---- --:-- AM

Hi,
I am calculating a value in Looker Studio via a formula14-03-2025_11-38-55.jpg

Although I deduct 0 from a positiv value, Looker shows me 0 in the calculated Column "ErgnMb"
14-03-2025_11-37-30.jpg
Can someone tell me the reason. What do I have to do to get 3.202,96 in Column "ErgnMB"?
Best regards,
Jörg

0 3 156
Topic Labels
0 Likes
3 REPLIES 3

Posted on --/--/---- --:-- AM
Looker_Studio_B
Silver 1
Silver 1
Reply posted on --/--/---- --:-- AM

Hi,

Do you have some null rows in there? Can you try SUM(IFNULL(ergvm..,0))-SUM(IFNULL(cost,0))?

0 Likes

Posted on --/--/---- --:-- AM
阿泰
Silver 1
Silver 1
Reply posted on --/--/---- --:-- AM
@JFL73 wrote:

3.202,96

Could this be a number format issue? It seems like it might be in a 'string' format, which is causing the problem. Please check the data source and verify the data type of the column to ensure it's set to 'number'.

0 Likes

Posted on --/--/---- --:-- AM
Looker_Studio_B
Silver 1
Silver 1
Reply posted on --/--/---- --:-- AM

Other smoking gun: is this a dimension or a metric?!

0 Likes