Calculated Data Expression in Rpt Column Not Working | Community
Skip to main content
N
NickVa7
Level 9
February 26, 2020
Question

Calculated Data Expression in Rpt Column Not Working

  • February 26, 2020
  • 2 replies
  • 511 views
Hi WF Community, I'm trying to subtract the values of two custom fields in a task report by using a caluclated column in my report. However, it's not displaying any results. - I have two custom currency fields: Total Invoice Amount & Tekside Cost - My text mode data expression is as such: displayname=Tekside PnL textmode=true valueexpression=SUB(INV - Total Invoice Amount,Tekside Cost) valueformat=HTML Does anyone know what I'm doing wrong? I tested replacing the field label names with actual numbers (e.g. 4 and 2) and it displayed the calculation properly on the report when I ran it this way (but it's obviously not what I want). Thanks. Nick Nick Valeriote
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

Doug_Den_Hoed_AtAppStore
Community Advisor
Doug_Den_Hoed_AtAppStoreCommunity Advisor
Community Advisor
February 26, 2020

Hi Nick,

I suspect it might be the "-" (a Special Character) that is confusing the formula parser, and suggest you try this, to give it a hint:

valueexpression=SUB({DE:INV - Total Invoice Amount},{DE:Tekside Cost})

Regards,

Doug

P.S. DE stands for "data extensions", for those who've wondered, and means "custom data"

N
NickVa7Author
Level 9
February 28, 2020
Your new valueexpression worked, thanks, Douglas! Ahh, ok, that's what DE stands for. Nick Valeriote
Terms & ConditionsAccessibility statement

Loading footer...